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 849: INSERT into bom_sub_comps_interface (

845: );
846:
847: stmt_num := 9;
848: /* INSERTS ONLY - Load rows from component interface into sub comp interface*/
849: INSERT into bom_sub_comps_interface (
850: SUBSTITUTE_COMPONENT_ID,
851: SUBSTITUTE_COMP_NUMBER,
852: ORGANIZATION_ID,
853: LAST_UPDATE_DATE,

Line 1369: BOM_SUB_COMPS_INTERFACE

1365: in the interface table
1366: REQUIRES
1367:
1368: MODIFIES
1369: BOM_SUB_COMPS_INTERFACE
1370: MTL_INTERFACE_ERRORS
1371: RETURNS
1372: 0 if successful
1373: SQLCODE if unsuccessful

Line 1401: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1397:
1398: stmt_num := 1;
1399: /* Resolve the Component_sequence_id for all the records */
1400:
1401: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1402: SET(bill_sequence_id, component_item_id, effectivity_date,
1403: operation_seq_num, from_end_item_unit_number)
1404: = (select bill_sequence_id, component_item_id,
1405: EFFECTIVITY_DATE, OPERATION_SEQ_NUM, FROM_END_ITEM_UNIT_NUMBER

Line 1425: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1421:
1422: stmt_num := 2;
1423: /* Resolve the Bill sequence ids for updates and deletes */
1424:
1425: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1426: SET(assembly_item_id, organization_id, alternate_bom_designator)
1427: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
1428: FROM bom_structures_b BBM1
1429: WHERE BBM1.bill_sequence_id = BSCI.bill_sequence_id)

Line 1448: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1444: stmt_num := 3;
1445: /* Update Organization Code using Organization_id
1446: this also needed if Organization_id is given and code is not given*/
1447:
1448: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1449: SET organization_code = (SELECT organization_code
1450: FROM MTL_PARAMETERS mp1
1451: WHERE mp1.organization_id = BSCI.organization_id)
1452: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1471: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1467: stmt_num := 4;
1468: /* Update Organization_ids if organization_code is given org id is null.
1469: Orgnaization_id information is needed in the next steps */
1470:
1471: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1472: SET organization_id = (SELECT organization_id
1473: FROM MTL_PARAMETERS mp1
1474: WHERE mp1.organization_code = BSCI.organization_code)
1475: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 1491: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1487:
1488: stmt_num := 5;
1489: /* Update Assembly Item name */
1490:
1491: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1492: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1493: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1494: WHERE mvl1.inventory_item_id = BSCI.assembly_item_id
1495: AND mvl1.organization_id = BSCI.organization_id)

Line 1515: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1511:
1512: stmt_num := 6;
1513: /* Update Component Item name */
1514:
1515: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1516: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
1517: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1518: WHERE mvl1.inventory_item_id = BSCI.component_item_id
1519: AND mvl1.organization_id = BSCI.organization_id)

Line 1539: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1535:
1536: stmt_num := 7;
1537: /* Update Substitute Component name if Id is given */
1538:
1539: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1540: SET SUBSTITUTE_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
1541: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1542: WHERE mvl1.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
1543: and mvl1.organization_id = BSCI.organization_id)

Line 1564: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1560:
1561: stmt_num := 8;
1562: /* Update new Substitute Component name if Id is given */
1563:
1564: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1565: SET NEW_SUB_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
1566: FROM MTL_SYSTEM_ITEMS_KFV mvl1
1567: WHERE mvl1.inventory_item_id = BSCI.NEW_SUB_COMP_ID
1568: and mvl1.organization_id = BSCI.organization_id)

Line 1587: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

1583:
1584: stmt_num := 9;
1585: /* Assign transaction ids */
1586:
1587: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
1588: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
1589: transaction_type = upper(transaction_type)
1590: WHERE transaction_id is null
1591: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)

Line 1652: from BOM_SUB_COMPS_INTERFACE BSCI

1648: NVL(PROGRAM_APPLICATION_ID, prog_appid),
1649: NVL(PROGRAM_ID, prog_id),
1650: NVL(PROGRAM_UPDATE_DATE, sysdate)
1651:
1652: from BOM_SUB_COMPS_INTERFACE BSCI
1653: where (organization_code is null or ASSEMBLY_ITEM_NUMBER is null)
1654: and transaction_id is not null
1655: and process_flag =1
1656: AND change_notice is null --added for bug 9673701

Line 1664: Update BOM_SUB_COMPS_INTERFACE

1660: ( (p_batch_id IS NULL) AND (BSCI.batch_id IS NULL) )
1661: OR ( p_batch_id = BSCI.batch_id )
1662: );
1663:
1664: Update BOM_SUB_COMPS_INTERFACE
1665: set process_flag = 3
1666: where (ASSEMBLY_ITEM_NUMBER is null or Organization_code is null)
1667: and transaction_id is not null
1668: and process_flag =1

Line 2873: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

2869: RETURN l_return_status;
2870: END IF;
2871: */
2872:
2873: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
2874: SET(bill_sequence_id, component_item_id, effectivity_date,
2875: operation_seq_num, from_end_item_unit_number)
2876: = (select bill_sequence_id, component_item_id,
2877: EFFECTIVITY_DATE, OPERATION_SEQ_NUM, FROM_END_ITEM_UNIT_NUMBER

Line 2895: UPDATE bom_sub_comps_interface BSCI

2891:
2892:
2893: /* Resolve the Bill sequence ids for updates and deletes */
2894:
2895: UPDATE bom_sub_comps_interface BSCI
2896: SET(assembly_item_id, organization_id, ALTERNATE_BOM_DESIGNATOR)
2897: = (SELECT assembly_item_id, organization_id , alternate_bom_designator
2898: FROM BOM_BILL_OF_MATERIALS BBM1
2899: WHERE BBM1.bill_sequence_id = BSCI.bill_sequence_id)

Line 2915: UPDATE bom_sub_comps_interface BSCI

2911:
2912: /* Update Organization Code using Organization_id
2913: this also needed if Organization_id is given and code is not given*/
2914:
2915: UPDATE bom_sub_comps_interface BSCI
2916: SET organization_code = (SELECT organization_code
2917: FROM MTL_PARAMETERS mp1
2918: WHERE mp1.organization_id = BSCI.organization_id)
2919: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2935: UPDATE bom_sub_comps_interface BSCI

2931:
2932: /* Update Organization_ids if organization_code is given org id is null.
2933: Orgnaization_id information is needed in the next steps */
2934:
2935: UPDATE bom_sub_comps_interface BSCI
2936: SET organization_id = (SELECT organization_id
2937: FROM MTL_PARAMETERS mp1
2938: WHERE mp1.organization_code = BSCI.organization_code)
2939: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import

Line 2952: UPDATE bom_sub_comps_interface BSCI

2948:
2949:
2950: /* Update Assembly Item name */
2951:
2952: UPDATE bom_sub_comps_interface BSCI
2953: SET ASSEMBLY_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2954: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2955: WHERE mvl1.inventory_item_id = BSCI.assembly_item_id
2956: AND mvl1.organization_id = BSCI.organization_id)

Line 2971: UPDATE bom_sub_comps_interface BSCI

2967: WHERE mvl12.inventory_item_id = BSCI.assembly_item_id
2968: AND mvl12.organization_id = BSCI.organization_id);
2969:
2970: /* Update the Assembly_item_id */
2971: UPDATE bom_sub_comps_interface BSCI
2972: SET Assembly_item_id = (SELECT inventory_item_id
2973: FROM mtl_system_items_kfv mvll
2974: WHERE mvll.concatenated_segments = BSCI.Assembly_item_number
2975: AND mvll.organization_id = BSCI.organization_id)

Line 2987: UPDATE bom_sub_comps_interface BSCI

2983: OR ( p_batch_id = BSCI.batch_id )
2984: );
2985:
2986: /* Update Component Item name */
2987: UPDATE bom_sub_comps_interface BSCI
2988: SET COMPONENT_ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
2989: FROM MTL_SYSTEM_ITEMS_KFV mvl1
2990: WHERE mvl1.inventory_item_id = BSCI.component_item_id
2991: AND mvl1.organization_id = BSCI.organization_id)

Line 3007: UPDATE bom_sub_comps_interface BSCI

3003: AND mvl12.organization_id = BSCI.organization_id);
3004:
3005:
3006: /* Update the Component_item_id */
3007: UPDATE bom_sub_comps_interface BSCI
3008: SET Component_item_id = (SELECT inventory_item_id
3009: FROM mtl_system_items_kfv mvll
3010: WHERE mvll.concatenated_segments = BSCI.Component_item_number
3011: AND mvll.organization_id = BSCI.organization_id)

Line 3023: UPDATE bom_sub_comps_interface BSCI

3019: OR ( p_batch_id = BSCI.batch_id )
3020: );
3021:
3022: /* Set the Bill Seqeunce Ids */
3023: UPDATE bom_sub_comps_interface BSCI
3024: SET bill_sequence_id = (SELECT bill_sequence_id
3025: FROM bom_bill_of_materials bom
3026: WHERE bom.assembly_item_id = BSCI.assembly_item_id
3027: AND bom.organization_id = BSCI.organization_id

Line 3041: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

3037: OR ( p_batch_id = BSCI.batch_id )
3038: );
3039:
3040: /* Update the component_sequence_id */
3041: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3042: SET COMPONENT_SEQUENCE_ID
3043: = (SELECT COMPONENT_SEQUENCE_ID
3044: FROM BOM_INVENTORY_COMPONENTS BIC
3045: WHERE BIC.bill_sequence_id = BSCI.bill_Sequence_id

Line 3061: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

3057: OR ( p_batch_id = BSCI.batch_id )
3058: );
3059:
3060:
3061: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3062: SET SUBSTITUTE_COMP_NUMBER = (SELECT concatenated_segments
3063: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3064: WHERE mvl1.inventory_item_id = BSCI.SUBSTITUTE_COMPONENT_ID
3065: and mvl1.organization_id = BSCI.organization_id)

Line 3082: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

3078: AND mvl12.organization_id = BSCI.organization_id);
3079:
3080: --Update Sub Comp Number If id is given
3081:
3082: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3083: SET SUBSTITUTE_COMPONENT_ID = (SELECT inventory_item_id
3084: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3085: WHERE mvl1.concatenated_segments = BSCI.SUBSTITUTE_COMP_NUMBER
3086: and mvl1.organization_id = BSCI.organization_id)

Line 3100: UPDATE BOM_SUB_COMPS_INTERFACE BSCI

3096: );
3097:
3098: --Update New Sub Comp Number
3099:
3100: UPDATE BOM_SUB_COMPS_INTERFACE BSCI
3101: SET NEW_SUB_COMP_NUMBER = (SELECT CONCATENATED_SEGMENTS
3102: FROM MTL_SYSTEM_ITEMS_KFV mvl1
3103: WHERE mvl1.inventory_item_id = BSCI.NEW_SUB_COMP_ID
3104: and mvl1.organization_id = BSCI.organization_id)

Line 3123: UPDATE bom_sub_comps_interface BSCI

3119:
3120:
3121:
3122: /*Update the transaction_types */
3123: UPDATE bom_sub_comps_interface BSCI
3124: SET Transaction_Type = G_Update
3125: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3126: AND transaction_type = 'SYNC'
3127: AND COMPONENT_SEQUENCE_ID is not null

Line 3139: UPDATE bom_sub_comps_interface BSCI

3135: WHERE BSCI2.COMPONENT_SEQUENCE_ID = BSCI.COMPONENT_SEQUENCE_ID
3136: AND NVL(BSCI2.ACD_TYPE, 1) = NVL(BSCI.ACD_TYPE, 1) );
3137:
3138: /*Update the transaction_types */
3139: UPDATE bom_sub_comps_interface BSCI
3140: SET Transaction_Type = G_Create
3141: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
3142: AND transaction_type = 'SYNC'
3143: AND

Line 3151: UPDATE bom_sub_comps_interface BSCI

3147: );
3148:
3149: /* Assign transaction ids */
3150:
3151: UPDATE bom_sub_comps_interface BSCI
3152: SET transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.nextval,
3153: transaction_type = upper(transaction_type)
3154: WHERE transaction_id is null
3155: AND upper(transaction_type) in (G_Create, G_Update, G_Delete)