Hi, im tyring to create a query for a quick report to easily export a list of characteristic values for variable part number, i cannot see how this report connects the object key from this view with the object key from the technical_specification_both table where the values are stored. i looked at this once before a long time ago and i recall i used an API could anyone help ?
Hi All, im looking to produce a report to output the multilevel materials and components on a finished serialized part or even at the shop order level rather than serial level.I cant find a view in IFS and am having difficulty finding which tables and views will allow me to make a query to establish this connection.i have tried to describe the kind of connection im looking for below but for N levels and N componentsshop ord component a shop ord component 1 shop ord component # component # component 2 shop ord component # component # component B shop ord component 1 shop ord component # component # component 2 shop ord component # component #any help or support anyone can offer to point me in the right direction will be appreciated.
Hi All, i have a SQL query to join 2 simple datasets, i am receiving an error saying "PROD_STRUCT_ALTERNATE_CFV"."PART_NO": invalid identifierFailed executing statement (ORA-00904: "PROD_STRUCT_ALTERNATE_CFV"."PART_NO": invalid identifierrelates ot the ON part of the statement.If anyone can help i would appreciate it.the basic select query was working before i modified it to include the join from the other table.SQL is as belowSELECT objid,objkey,bom_type,alternative_no,contract,part_no,cf$_total_plastic_weight,cf$_total_regrind_weightweight_netFROM ((SELECT objid,objkey,bom_type,alternative_no,contract,part_no,cf$_total_plastic_weight,cf$_total_regrind_weightFROM prod_struct_alternate_cfv WHERE alternative_no ='*' AND bom_type ='Manufacturing' )LEFT JOIN (SELECT part_no, weight_net FROM part_catalog where part_no is not null)ON part_catalog.part_no_cfv = prod_struct_alternate_cfv.part_no )
Hi All, i have a scenario where i would like to add a component with the same configuration into multiple structure alternate lines as a mass update, i would normally use the find and replace on the components per product view for this when it is a replacement but i want to do the same but to add a component not replace an existing one.does anyone know if it is possible without migration jobthanks in advance for any help or advice
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.