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
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.
Already have an account? Login
No account yet? Create an account
Enter your 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.