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_SUB_COMPS_INTERFACE

Line 835: INSERT into bom_sub_comps_interface (

831: );
832:
833: stmt_num := 9;
834: /* INSERTS ONLY - Load rows from component interface into sub comp interface*/
835: INSERT into bom_sub_comps_interface (
836: SUBSTITUTE_COMPONENT_ID,
837: SUBSTITUTE_COMP_NUMBER,
838: ORGANIZATION_ID,
839: LAST_UPDATE_DATE,

Line 1342: BOM_SUB_COMPS_INTERFACE

1338: in the interface table
1339: REQUIRES
1340:
1341: MODIFIES
1342: BOM_SUB_COMPS_INTERFACE
1343: MTL_INTERFACE_ERRORS
1344: RETURNS
1345: 0 if successful
1346: SQLCODE if unsuccessful

Line 1374: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1370:
1371: stmt_num := 1;
1372: /* Resolve the Component_sequence_id for all the records */
1373:
1374: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1375: SET(bill_sequence_id, component_item_id, effectivity_date,
1376: operation_seq_num, from_end_item_unit_number)
1377: = (select bill_sequence_id, component_item_id,
1378: EFFECTIVITY_DATE, OPERATION_SEQ_NUM, FROM_END_ITEM_UNIT_NUMBER

Line 1397: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1393:
1394: stmt_num := 2;
1395: /* Resolve the Bill sequence ids for updates and deletes */
1396:
1397: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1398: SET(assembly_item_id, organization_id, alternate_bom_designator)
1399: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1400: FROM bom_structures_b BBM1
1401: WHERE BBM1.bill_sequence_id = BSCI.bill_sequence_id)

Line 1419: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1415: stmt_num := 3;
1416: /* Update Organization Code using Organization_id
1417: this also needed if Organization_id is given and code is not given*/
1418:
1419: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1420: SET organization_code = (SELECT organization_code
1421: FROM MTL_PARAMETERS mp1
1422: WHERE mp1.organization_id = BSCI.organization_id)
1423: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1441: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1437: stmt_num := 4;
1438: /* Update Organization_ids if organization_code is given org id is null.
1439: Orgnaization_id information is needed in the next steps */
1440:
1441: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1442: SET organization_id = (SELECT organization_id
1443: FROM MTL_PARAMETERS mp1
1444: WHERE mp1.organization_code = BSCI.organization_code)
1445: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1460: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1456:
1457: stmt_num := 5;
1458: /* Update Assembly Item name */
1459:
1460: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1461: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1462: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1463: WHERE mvl1.inventory_item_id = BSCI.assembly_item_id
1464: AND mvl1.organization_id = BSCI.organization_id)

Line 1483: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1479:
1480: stmt_num := 6;
1481: /* Update Component Item name */
1482:
1483: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1484: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1485: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1486: WHERE mvl1.inventory_item_id = BSCI.component_item_id
1487: AND mvl1.organization_id = BSCI.organization_id)

Line 1506: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1502:
1503: stmt_num := 7;
1504: /* Update Substitute Component name if Id is given */
1505:
1506: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1507: SET SUBSTITUTE_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
1508: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1509: WHERE mvl1.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
1510: and mvl1.organization_id = BSCI.organization_id)

Line 1530: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1526:
1527: stmt_num := 8;
1528: /* Update new Substitute Component name if Id is given */
1529:
1530: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1531: SET NEW_SUB_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
1532: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1533: WHERE mvl1.inventory_item_id = BSCI.NEW_SUB_COMP_ID
1534: and mvl1.organization_id = BSCI.organization_id)

Line 1552: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1548:
1549: stmt_num := 9;
1550: /* Assign transaction ids */
1551:
1552: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1553: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1554: transaction_type = upper(transaction_type)
1555: WHERE transaction_id is null
1556: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 1616: from BOM_SUB_COMPS_INTERFACE BSCI

1612: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1613: NVL(PROGRAM_ID, prog_id),
1614: NVL(PROGRAM_UPDATE_DATE, sysdate)
1615:
1616: from BOM_SUB_COMPS_INTERFACE BSCI
1617: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1618: and transaction_id is not null
1619: and process_flag =1
1620: and (all_org = 1 OR (all_org = 2 AND organization_id = org_id))

Line 1627: Update BOM_SUB_COMPS_INTERFACE

1623: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1624: OR ( p_batch_id = BSCI.batch_id )
1625: );
1626:
1627: Update BOM_SUB_COMPS_INTERFACE
1628: set process_flag = 3
1629: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1630: and transaction_id is not null
1631: and process_flag =1

Line 2829: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

2825: RETURN l_return_status;
2826: END IF;
2827: */
2828:
2829: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
2830: SET(bill_sequence_id, component_item_id, effectivity_date,
2831: operation_seq_num, from_end_item_unit_number)
2832: = (select bill_sequence_id, component_item_id,
2833: EFFECTIVITY_DATE, OPERATION_SEQ_NUM, FROM_END_ITEM_UNIT_NUMBER

Line 2851: UPDATE bom_sub_comps_interface BSCI

2847:
2848:
2849: /* Resolve the Bill sequence ids for updates and deletes */
2850:
2851: UPDATE bom_sub_comps_interface BSCI
2852: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
2853: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
2854: FROM BOM_BILL_OF_MATERIALS BBM1
2855: WHERE BBM1.bill_sequence_id = BSCI.bill_sequence_id)

Line 2871: UPDATE bom_sub_comps_interface BSCI

2867:
2868: /* Update Organization Code using Organization_id
2869: this also needed if Organization_id is given and code is not given*/
2870:
2871: UPDATE bom_sub_comps_interface BSCI
2872: SET organization_code = (SELECT organization_code
2873: FROM MTL_PARAMETERS mp1
2874: WHERE mp1.organization_id = BSCI.organization_id)
2875: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2891: UPDATE bom_sub_comps_interface BSCI

2887:
2888: /* Update Organization_ids if organization_code is given org id is null.
2889: Orgnaization_id information is needed in the next steps */
2890:
2891: UPDATE bom_sub_comps_interface BSCI
2892: SET organization_id = (SELECT organization_id
2893: FROM MTL_PARAMETERS mp1
2894: WHERE mp1.organization_code = BSCI.organization_code)
2895: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2908: UPDATE bom_sub_comps_interface BSCI

2904:
2905:
2906: /* Update Assembly Item name */
2907:
2908: UPDATE bom_sub_comps_interface BSCI
2909: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2910: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2911: WHERE mvl1.inventory_item_id = BSCI.assembly_item_id
2912: AND mvl1.organization_id = BSCI.organization_id)

Line 2927: UPDATE bom_sub_comps_interface BSCI

2923: WHERE mvl12.inventory_item_id = BSCI.assembly_item_id
2924: AND mvl12.organization_id = BSCI.organization_id);
2925:
2926: /* Update the Assembly_item_id */
2927: UPDATE bom_sub_comps_interface BSCI
2928: SET Assembly_item_id = (SELECT inventory_item_id
2929: FROM mtl_system_items_kfv mvll
2930: WHERE mvll.concatenated_segments = BSCI.Assembly_item_number
2931: AND mvll.organization_id = BSCI.organization_id)

Line 2943: UPDATE bom_sub_comps_interface BSCI

2939: OR ( p_batch_id = BSCI.batch_id )
2940: );
2941:
2942: /* Update Component Item name */
2943: UPDATE bom_sub_comps_interface BSCI
2944: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2945: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2946: WHERE mvl1.inventory_item_id = BSCI.component_item_id
2947: AND mvl1.organization_id = BSCI.organization_id)

Line 2963: UPDATE bom_sub_comps_interface BSCI

2959: AND mvl12.organization_id = BSCI.organization_id);
2960:
2961:
2962: /* Update the Component_item_id */
2963: UPDATE bom_sub_comps_interface BSCI
2964: SET Component_item_id = (SELECT inventory_item_id
2965: FROM mtl_system_items_kfv mvll
2966: WHERE mvll.concatenated_segments = BSCI.Component_item_number
2967: AND mvll.organization_id = BSCI.organization_id)

Line 2979: UPDATE bom_sub_comps_interface BSCI

2975: OR ( p_batch_id = BSCI.batch_id )
2976: );
2977:
2978: /* Set the Bill Seqeunce Ids */
2979: UPDATE bom_sub_comps_interface BSCI
2980: SET bill_sequence_id = (SELECT bill_sequence_id
2981: FROM bom_bill_of_materials bom
2982: WHERE bom.assembly_item_id = BSCI.assembly_item_id
2983: AND bom.organization_id = BSCI.organization_id

Line 2997: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

2993: OR ( p_batch_id = BSCI.batch_id )
2994: );
2995:
2996: /* Update the component_sequence_id */
2997: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
2998: SET COMPONENT_SEQUENCE_ID
2999: = (SELECT COMPONENT_SEQUENCE_ID
3000: FROM BOM_INVENTORY_COMPONENTS BIC
3001: WHERE BIC.bill_sequence_id = BSCI.bill_Sequence_id

Line 3017: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

3013: OR ( p_batch_id = BSCI.batch_id )
3014: );
3015:
3016:
3017: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3018: SET SUBSTITUTE_COMP_NUMBER = (SELECT concatenated_segments
3019: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3020: WHERE mvl1.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
3021: and mvl1.organization_id = BSCI.organization_id)

Line 3038: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

3034: AND mvl12.organization_id = BSCI.organization_id);
3035:
3036: --Update Sub Comp Number If id is given
3037:
3038: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3039: SET SUBSTITUTE_COMPONENT_ID = (SELECT inventory_item_id
3040: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3041: WHERE mvl1.concatenated_segments = BSCI.SUBSTITUTE_COMP_NUMBER
3042: and mvl1.organization_id = BSCI.organization_id)

Line 3056: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

3052: );
3053:
3054: --Update New Sub Comp Number
3055:
3056: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3057: SET NEW_SUB_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
3058: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3059: WHERE mvl1.inventory_item_id = BSCI.NEW_SUB_COMP_ID
3060: and mvl1.organization_id = BSCI.organization_id)

Line 3079: UPDATE bom_sub_comps_interface BSCI

3075:
3076:
3077:
3078: /*Update the transaction_types */
3079: UPDATE bom_sub_comps_interface BSCI
3080: SET Transaction_Type = G_Update
3081: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3082: AND transaction_type = 'SYNC'
3083: AND COMPONENT_SEQUENCE_ID is not null

Line 3095: UPDATE bom_sub_comps_interface BSCI

3091: WHERE BSCI2.COMPONENT_SEQUENCE_ID = BSCI.COMPONENT_SEQUENCE_ID
3092: AND NVL(BSCI2.ACD_TYPE, 1) = NVL(BSCI.ACD_TYPE, 1) );
3093:
3094: /*Update the transaction_types */
3095: UPDATE bom_sub_comps_interface BSCI
3096: SET Transaction_Type = G_Create
3097: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3098: AND transaction_type = 'SYNC'
3099: AND

Line 3107: UPDATE bom_sub_comps_interface BSCI

3103: );
3104:
3105: /* Assign transaction ids */
3106:
3107: UPDATE bom_sub_comps_interface BSCI
3108: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
3109: transaction_type = upper(transaction_type)
3110: WHERE transaction_id is null
3111: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)