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 926: INSERT INTO bom_ref_desgs_interface (

922: stmt_num := 10;
923:
924: /* INSERTS ONLY - Load rows from component interface into ref desgs interface*/
925:
926: INSERT INTO bom_ref_desgs_interface (
927: COMPONENT_REFERENCE_DESIGNATOR,
928: LAST_UPDATE_DATE,
929: LAST_UPDATED_BY,
930: CREATION_DATE,

Line 1090: BOM_REF_DESGS_INTERFACE

1086: in the interface table
1087: REQUIRES
1088:
1089: MODIFIES
1090: BOM_REF_DESGS_INTERFACE
1091: MTL_INTERFACE_ERRORS
1092: RETURNS
1093: 0 if successful
1094: SQLCODE if unsuccessful

Line 1122: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1118:
1119: stmt_num := 1;
1120: /* Resolve the Component_sequence_id for all the records */
1121:
1122: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1123: SET(bill_sequence_id, component_item_id, effectivity_date,
1124: operation_seq_num, from_end_item_unit_number)
1125: = (SELECT bill_sequence_id, component_item_id,
1126: effectivity_date, operation_seq_num, from_end_item_unit_number

Line 1146: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1142:
1143: stmt_num := 2;
1144: /* Resolve the Bill sequence ids for updates and deletes */
1145:
1146: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1147: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
1148: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1149: FROM bom_structures_b BBM1
1150: WHERE BBM1.bill_sequence_id = BRDI.bill_sequence_id)

Line 1169: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1165: stmt_num := 3;
1166: /* Update Organization Code using Organization_id
1167: this also needed if Organization_id is given and code is not given*/
1168:
1169: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1170: SET organization_code = (SELECT organization_code
1171: FROM MTL_PARAMETERS mp1
1172: WHERE mp1.organization_id = BRDI.organization_id)
1173: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1192: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1188: stmt_num := 4;
1189: /* Update Organization_ids if organization_code is given org id is null.
1190: Orgnaization_id information is needed in the next steps */
1191:
1192: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1193: SET organization_id = (SELECT organization_id
1194: FROM MTL_PARAMETERS mp1
1195: WHERE mp1.organization_code = BRDI.organization_code)
1196: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1212: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1208:
1209: stmt_num := 5;
1210: /* Update Assembly Item name */
1211:
1212: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1213: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1214: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1215: WHERE mvl1.inventory_item_id = BRDI.assembly_item_id
1216: and mvl1.organization_id = BRDI.organization_id)

Line 1236: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1232:
1233: stmt_num := 6;
1234: /* Update Component Item name */
1235:
1236: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1237: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1238: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1239: WHERE mvl1.inventory_item_id = BRDI.component_item_id
1240: AND mvl1.organization_id = BRDI.organization_id)

Line 1260: UPDATE BOM_REF_DESGS_INTERFACE BRDI

1256:
1257: stmt_num := 7;
1258: /* Assign transaction ids */
1259:
1260: UPDATE BOM_REF_DESGS_INTERFACE BRDI
1261: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1262: transaction_type = upper(transaction_type)
1263: WHERE transaction_id is null
1264: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 1313: 'BOM_REF_DESGS_INTERFACE',

1309: BRDI.transaction_id,
1310: MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1311: Null,
1312: null,
1313: 'BOM_REF_DESGS_INTERFACE',
1314: decode ( BRDI.Organization_code, null, msg_name1,msg_name2),
1315: decode ( BRDI.Organization_code, null, msg_text1,msg_text2),
1316: NVL(LAST_UPDATE_DATE, SYSDATE),
1317: NVL(LAST_UPDATED_BY, user_id),

Line 1325: from BOM_REF_DESGS_INTERFACE BRDI

1321: NVL(REQUEST_ID, req_id),
1322: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1323: NVL(PROGRAM_ID, prog_id),
1324: NVL(PROGRAM_UPDATE_DATE, sysdate)
1325: from BOM_REF_DESGS_INTERFACE BRDI
1326: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1327: and transaction_id is not null
1328: and process_flag =1
1329: AND change_notice is null --added for bug 9673701

Line 1337: Update BOM_REF_DESGS_INTERFACE

1333: ( (p_batch_id IS NULL) AND (BRDI.batch_id IS NULL) )
1334: OR ( p_batch_id = BRDI.batch_id )
1335: );
1336:
1337: Update BOM_REF_DESGS_INTERFACE
1338: set process_flag = 3
1339: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1340: and transaction_id is not null
1341: and process_flag =1

Line 2608: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2604: RETURN l_return_status;
2605: END IF;
2606: */
2607:
2608: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2609: SET(bill_sequence_id, component_item_id, effectivity_date,
2610: operation_seq_num, from_end_item_unit_number)
2611: = (SELECT bill_sequence_id, component_item_id,
2612: effectivity_date, operation_seq_num, from_end_item_unit_number

Line 2629: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2625:
2626:
2627: /* Resolve the Bill sequence ids for updates and deletes */
2628:
2629: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2630: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
2631: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
2632: FROM BOM_BILL_OF_MATERIALS BBM1
2633: WHERE BBM1.bill_sequence_id = BRDI.bill_sequence_id)

Line 2649: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2645:
2646: /* Update Organization Code using Organization_id
2647: this also needed if Organization_id is given and code is not given*/
2648:
2649: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2650: SET organization_code = (SELECT organization_code
2651: FROM MTL_PARAMETERS mp1
2652: WHERE mp1.organization_id = BRDI.organization_id)
2653: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2669: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2665:
2666: /* Update Organization_ids if organization_code is given org id is null.
2667: Orgnaization_id information is needed in the next steps */
2668:
2669: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2670: SET organization_id = (SELECT organization_id
2671: FROM MTL_PARAMETERS mp1
2672: WHERE mp1.organization_code = BRDI.organization_code)
2673: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2686: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2682:
2683:
2684: /* Update Assembly Item name */
2685:
2686: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2687: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2688: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2689: WHERE mvl1.inventory_item_id = BRDI.assembly_item_id
2690: AND mvl1.organization_id = BRDI.organization_id)

Line 2705: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2701: WHERE mvl12.inventory_item_id = BRDI.assembly_item_id
2702: AND mvl12.organization_id = BRDI.organization_id);
2703:
2704: /* Update the Assembly_item_id */
2705: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2706: SET Assembly_item_id = (SELECT inventory_item_id
2707: FROM mtl_system_items_kfv mvll
2708: WHERE mvll.concatenated_segments = BRDI.Assembly_item_number
2709: AND mvll.organization_id = BRDI.organization_id)

Line 2721: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2717: OR ( p_batch_id = BRDI.batch_id )
2718: );
2719:
2720: /* Update Component Item name */
2721: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2722: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2723: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2724: WHERE mvl1.inventory_item_id = BRDI.component_item_id
2725: AND mvl1.organization_id = BRDI.organization_id)

Line 2741: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2737: AND mvl12.organization_id = BRDI.organization_id);
2738:
2739:
2740: /* Update the Component_item_id */
2741: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2742: SET Component_item_id = (SELECT inventory_item_id
2743: FROM mtl_system_items_kfv mvll
2744: WHERE mvll.concatenated_segments = BRDI.Component_item_number
2745: AND mvll.organization_id = BRDI.organization_id)

Line 2757: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2753: OR ( p_batch_id = BRDI.batch_id )
2754: );
2755:
2756: /* Set the Bill Seqeunce Ids */
2757: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2758: SET bill_sequence_id = (SELECT bill_sequence_id
2759: FROM bom_structures_b bom
2760: WHERE bom.assembly_item_id = BRDI.assembly_item_id
2761: AND bom.organization_id = BRDI.organization_id

Line 2775: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2771: OR ( p_batch_id = BRDI.batch_id )
2772: );
2773:
2774: /* Update the component_sequence_id */
2775: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2776: SET COMPONENT_SEQUENCE_ID
2777: = (SELECT COMPONENT_SEQUENCE_ID
2778: FROM bom_components_b BIC
2779: WHERE BIC.bill_sequence_id = BRDI.bill_Sequence_id

Line 2795: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2791: OR ( p_batch_id = BRDI.batch_id )
2792: );
2793:
2794:
2795: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2796: SET Assembly_Item_Revision_Id = (SELECT mrb.revision_id
2797: FROM mtl_item_revisions_b mrb
2798: WHERE mrb.inventory_item_id = BRDI.Assembly_item_id
2799: AND mrb.organization_id = BRDI.organization_id

Line 2813: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2809: OR ( p_batch_id = BRDI.batch_id )
2810: );
2811:
2812: /*Update the transaction_types */
2813: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2814: SET Transaction_Type = G_Update
2815: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2816: AND transaction_type = 'SYNC'
2817: AND COMPONENT_SEQUENCE_ID is not null

Line 2830: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2826: AND BRDI2.COMPONENT_REFERENCE_DESIGNATOR = BRDI.COMPONENT_REFERENCE_DESIGNATOR
2827: AND NVL(BRDI2.ACD_TYPE, 1) = NVL(BRDI.ACD_TYPE, 1) );
2828:
2829: /*Update the transaction_types */
2830: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2831: SET Transaction_Type = G_Create
2832: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
2833: AND transaction_type = 'SYNC'
2834: AND

Line 2842: UPDATE BOM_REF_DESGS_INTERFACE BRDI

2838: );
2839:
2840: /* Assign transaction ids */
2841:
2842: UPDATE BOM_REF_DESGS_INTERFACE BRDI
2843: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
2844: transaction_type = upper(transaction_type)
2845: WHERE transaction_id is null
2846: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)