eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_REF_DESGS_INTERFACE

Line 911: INSERT INTO bom_ref_desgs_interface (

907: stmt_num := 10;
908:
909: /* INSERTS ONLY - Load rows from component interface into ref desgs interface*/
910:
911: INSERT INTO bom_ref_desgs_interface (
912: COMPONENT_REFERENCE_DESIGNATOR,
913: LAST_UPDATE_DATE,
914: LAST_UPDATED_BY,
915: CREATION_DATE,

Line 1072: BOM_REF_DESGS_INTERFACE

1068: in the interface table
1069: REQUIRES
1070:
1071: MODIFIES
1072: BOM_REF_DESGS_INTERFACE
1073: MTL_INTERFACE_ERRORS
1074: RETURNS
1075: 0 if successful
1076: SQLCODE if unsuccessful

Line 1104: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1100:
1101: stmt_num := 1;
1102: /* Resolve the Component_sequence_id for all the records */
1103:
1104: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1105: SET(bill_sequence_id, component_item_id, effectivity_date,
1106: operation_seq_num, from_end_item_unit_number)
1107: = (SELECT bill_sequence_id, component_item_id,
1108: effectivity_date, operation_seq_num, from_end_item_unit_number

Line 1127: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1123:
1124: stmt_num := 2;
1125: /* Resolve the Bill sequence ids for updates and deletes */
1126:
1127: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1128: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
1129: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1130: FROM bom_structures_b BBM1
1131: WHERE BBM1.bill_sequence_id = BRDI.bill_sequence_id)

Line 1149: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1145: stmt_num := 3;
1146: /* Update Organization Code using Organization_id
1147: this also needed if Organization_id is given and code is not given*/
1148:
1149: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1150: SET organization_code = (SELECT organization_code
1151: FROM MTL_PARAMETERS mp1
1152: WHERE mp1.organization_id = BRDI.organization_id)
1153: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1171: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1167: stmt_num := 4;
1168: /* Update Organization_ids if organization_code is given org id is null.
1169: Orgnaization_id information is needed in the next steps */
1170:
1171: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1172: SET organization_id = (SELECT organization_id
1173: FROM MTL_PARAMETERS mp1
1174: WHERE mp1.organization_code = BRDI.organization_code)
1175: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1190: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1186:
1187: stmt_num := 5;
1188: /* Update Assembly Item name */
1189:
1190: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1191: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1192: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1193: WHERE mvl1.inventory_item_id = BRDI.assembly_item_id
1194: and mvl1.organization_id = BRDI.organization_id)

Line 1213: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1209:
1210: stmt_num := 6;
1211: /* Update Component Item name */
1212:
1213: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1214: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1215: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1216: WHERE mvl1.inventory_item_id = BRDI.component_item_id
1217: AND mvl1.organization_id = BRDI.organization_id)

Line 1236: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1232:
1233: stmt_num := 7;
1234: /* Assign transaction ids */
1235:
1236: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1237: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1238: transaction_type = upper(transaction_type)
1239: WHERE transaction_id is null
1240: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 1288: 'BOM_REF_DESGS_INTERFACE',

1284: BRDI.transaction_id,
1285: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1286: Null,
1287: null,
1288: 'BOM_REF_DESGS_INTERFACE',
1289: decode ( BRDI.Organization_code, null, msg_name1,msg_name2),
1290: decode ( BRDI.Organization_code, null, msg_text1,msg_text2),
1291: NVL(LAST_UPDATE_DATE, SYSDATE),
1292: NVL(LAST_UPDATED_BY, user_id),

Line 1300: from BOM_REF_DESGS_INTERFACE BRDI

1296: NVL(REQUEST_ID, req_id),
1297: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1298: NVL(PROGRAM_ID, prog_id),
1299: NVL(PROGRAM_UPDATE_DATE, sysdate)
1300: from BOM_REF_DESGS_INTERFACE BRDI
1301: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1302: and transaction_id is not null
1303: and process_flag =1
1304: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id))

Line 1311: Update BOM_REF_DESGS_INTERFACE

1307: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1308: OR ( p_batch_id = BRDI.batch_id )
1309: );
1310:
1311: Update BOM_REF_DESGS_INTERFACE
1312: set process_flag = 3
1313: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1314: and transaction_id is not null
1315: and process_flag =1

Line 2564: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2560: RETURN l_return_status;
2561: END IF;
2562: */
2563:
2564: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2565: SET(bill_sequence_id, component_item_id, effectivity_date,
2566: operation_seq_num, from_end_item_unit_number)
2567: = (SELECT bill_sequence_id, component_item_id,
2568: effectivity_date, operation_seq_num, from_end_item_unit_number

Line 2585: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2581:
2582:
2583: /* Resolve the Bill sequence ids for updates and deletes */
2584:
2585: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2586: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
2587: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
2588: FROM BOM_BILL_OF_MATERIALS BBM1
2589: WHERE BBM1.bill_sequence_id = BRDI.bill_sequence_id)

Line 2605: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2601:
2602: /* Update Organization Code using Organization_id
2603: this also needed if Organization_id is given and code is not given*/
2604:
2605: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2606: SET organization_code = (SELECT organization_code
2607: FROM MTL_PARAMETERS mp1
2608: WHERE mp1.organization_id = BRDI.organization_id)
2609: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2625: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2621:
2622: /* Update Organization_ids if organization_code is given org id is null.
2623: Orgnaization_id information is needed in the next steps */
2624:
2625: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2626: SET organization_id = (SELECT organization_id
2627: FROM MTL_PARAMETERS mp1
2628: WHERE mp1.organization_code = BRDI.organization_code)
2629: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2642: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2638:
2639:
2640: /* Update Assembly Item name */
2641:
2642: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2643: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2644: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2645: WHERE mvl1.inventory_item_id = BRDI.assembly_item_id
2646: AND mvl1.organization_id = BRDI.organization_id)

Line 2661: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2657: WHERE mvl12.inventory_item_id = BRDI.assembly_item_id
2658: AND mvl12.organization_id = BRDI.organization_id);
2659:
2660: /* Update the Assembly_item_id */
2661: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2662: SET Assembly_item_id = (SELECT inventory_item_id
2663: FROM mtl_system_items_kfv mvll
2664: WHERE mvll.concatenated_segments = BRDI.Assembly_item_number
2665: AND mvll.organization_id = BRDI.organization_id)

Line 2677: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2673: OR ( p_batch_id = BRDI.batch_id )
2674: );
2675:
2676: /* Update Component Item name */
2677: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2678: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2679: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2680: WHERE mvl1.inventory_item_id = BRDI.component_item_id
2681: AND mvl1.organization_id = BRDI.organization_id)

Line 2697: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2693: AND mvl12.organization_id = BRDI.organization_id);
2694:
2695:
2696: /* Update the Component_item_id */
2697: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2698: SET Component_item_id = (SELECT inventory_item_id
2699: FROM mtl_system_items_kfv mvll
2700: WHERE mvll.concatenated_segments = BRDI.Component_item_number
2701: AND mvll.organization_id = BRDI.organization_id)

Line 2713: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2709: OR ( p_batch_id = BRDI.batch_id )
2710: );
2711:
2712: /* Set the Bill Seqeunce Ids */
2713: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2714: SET bill_sequence_id = (SELECT bill_sequence_id
2715: FROM bom_structures_b bom
2716: WHERE bom.assembly_item_id = BRDI.assembly_item_id
2717: AND bom.organization_id = BRDI.organization_id

Line 2731: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2727: OR ( p_batch_id = BRDI.batch_id )
2728: );
2729:
2730: /* Update the component_sequence_id */
2731: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2732: SET COMPONENT_SEQUENCE_ID
2733: = (SELECT COMPONENT_SEQUENCE_ID
2734: FROM bom_components_b BIC
2735: WHERE BIC.bill_sequence_id = BRDI.bill_Sequence_id

Line 2751: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2747: OR ( p_batch_id = BRDI.batch_id )
2748: );
2749:
2750:
2751: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2752: SET Assembly_Item_Revision_Id = (SELECT mrb.revision_id
2753: FROM mtl_item_revisions_b mrb
2754: WHERE mrb.inventory_item_id = BRDI.Assembly_item_id
2755: AND mrb.organization_id = BRDI.organization_id

Line 2769: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2765: OR ( p_batch_id = BRDI.batch_id )
2766: );
2767:
2768: /*Update the transaction_types */
2769: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2770: SET Transaction_Type = G_Update
2771: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2772: AND transaction_type = 'SYNC'
2773: AND COMPONENT_SEQUENCE_ID is not null

Line 2786: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2782: AND BRDI2.COMPONENT_REFERENCE_DESIGNATOR = BRDI.COMPONENT_REFERENCE_DESIGNATOR
2783: AND NVL(BRDI2.ACD_TYPE, 1) = NVL(BRDI.ACD_TYPE, 1) );
2784:
2785: /*Update the transaction_types */
2786: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2787: SET Transaction_Type = G_Create
2788: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2789: AND transaction_type = 'SYNC'
2790: AND

Line 2798: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2794: );
2795:
2796: /* Assign transaction ids */
2797:
2798: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2799: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2800: transaction_type = upper(transaction_type)
2801: WHERE transaction_id is null
2802: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)