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.BOMPASGB dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 36: BOM_INVENTORY_COMPS_INTERFACE

32: REQUIRES
33: err_text out buffer to return error message
34: MODIFIES
35: BOM_BILL_OF_MTLS_INTERFACE
36: BOM_INVENTORY_COMPS_INTERFACE
37: BOM_REF_DESGS_INTERFACE
38: BOM_SUB_COMPS_INTERFACE
39: MTL_INTERFACE_ERRORS
40: RETURNS

Line 73: update bom_inventory_comps_interface ori

69: end loop;
70:
71: stmt_num := 2;
72: loop
73: update bom_inventory_comps_interface ori
74: set organization_id = (select organization_id from
75: mtl_parameters a
76: where a.organization_code = ori.organization_code)
77: where process_flag = 1

Line 803: from bom_inventory_comps_interface

799: location_name LN, supply_locator_id SLI,
800: operation_seq_num OSN,
801: to_char(effectivity_date, 'YYYY/MM/DD HH24:MI') ED,
802: bom_item_type BIT
803: from bom_inventory_comps_interface
804: where process_flag = 1
805: and (all_org = 1
806: or
807: (all_org = 2 and organization_id = org_id)

Line 816: update bom_inventory_comps_interface

812: /*
813: ** assign transaction ids to all rows first
814: */
815: loop
816: update bom_inventory_comps_interface
817: set transaction_id = mtl_system_items_interface_s.nextval,
818: component_sequence_id = nvl(component_sequence_id,
819: bom_inventory_components_s.nextval)
820: where transaction_id is null

Line 843: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

839: prog_id => prog_id,
840: req_id => req_id,
841: trans_id => c1rec.TI,
842: error_text => err_text,
843: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
844: msg_name => 'BOM_ORG_ID_MISSING',
845: err_text => err_text);
846: update bom_inventory_comps_interface set
847: process_flag = 3

Line 846: update bom_inventory_comps_interface set

842: error_text => err_text,
843: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
844: msg_name => 'BOM_ORG_ID_MISSING',
845: err_text => err_text);
846: update bom_inventory_comps_interface set
847: process_flag = 3
848: where transaction_id = c1rec.TI;
849:
850: goto continue_loop;

Line 864: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

860: prog_id => prog_id,
861: req_id => req_id,
862: trans_id => c1rec.TI,
863: error_text => err_text,
864: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
865: msg_name => 'BOM_EFF_DATE_MISSING',
866: err_text => err_text);
867: update bom_inventory_comps_interface set
868: process_flag = 3

Line 867: update bom_inventory_comps_interface set

863: error_text => err_text,
864: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
865: msg_name => 'BOM_EFF_DATE_MISSING',
866: err_text => err_text);
867: update bom_inventory_comps_interface set
868: process_flag = 3
869: where transaction_id = c1rec.TI;
870:
871: goto continue_loop;

Line 893: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

889: prog_id => prog_id,
890: req_id => req_id,
891: trans_id => c1rec.TI,
892: error_text => err_text,
893: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
894: msg_name => 'BOM_ASSY_ITEM_MISSING',
895: err_text => err_text);
896: update bom_inventory_comps_interface set
897: process_flag = 3

Line 896: update bom_inventory_comps_interface set

892: error_text => err_text,
893: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
894: msg_name => 'BOM_ASSY_ITEM_MISSING',
895: err_text => err_text);
896: update bom_inventory_comps_interface set
897: process_flag = 3
898: where transaction_id = c1rec.TI;
899:
900: if (ret_code <> 0) then

Line 926: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

922: prog_id => prog_id,
923: req_id => req_id,
924: trans_id => c1rec.TI,
925: error_text => err_text,
926: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
927: msg_name => 'BOM_LOCATION_NAME_INVALID',
928: err_text => err_text);
929: update bom_inventory_comps_interface set
930: process_flag = 3

Line 929: update bom_inventory_comps_interface set

925: error_text => err_text,
926: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
927: msg_name => 'BOM_LOCATION_NAME_INVALID',
928: err_text => err_text);
929: update bom_inventory_comps_interface set
930: process_flag = 3
931: where transaction_id = c1rec.TI;
932:
933: if (ret_code <> 0) then

Line 958: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

954: prog_id => prog_id,
955: req_id => req_id,
956: trans_id => c1rec.TI,
957: error_text => err_text,
958: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
959: msg_name => 'BOM_BILL_SEQ_MISSING',
960: err_text => err_text);
961: update bom_inventory_comps_interface set
962: process_flag = 3

Line 961: update bom_inventory_comps_interface set

957: error_text => err_text,
958: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
959: msg_name => 'BOM_BILL_SEQ_MISSING',
960: err_text => err_text);
961: update bom_inventory_comps_interface set
962: process_flag = 3
963: where transaction_id = c1rec.TI;
964:
965: if (ret_code <> 0) then

Line 987: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

983: prog_id => prog_id,
984: req_id => req_id,
985: trans_id => c1rec.TI,
986: error_text => err_text,
987: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
988: msg_name => 'BOM_BILL_SEQ_MISSING',
989: err_text => err_text);
990: update bom_inventory_comps_interface set
991: process_flag = 3

Line 990: update bom_inventory_comps_interface set

986: error_text => err_text,
987: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
988: msg_name => 'BOM_BILL_SEQ_MISSING',
989: err_text => err_text);
990: update bom_inventory_comps_interface set
991: process_flag = 3
992: where transaction_id = c1rec.TI;
993:
994: if (ret_code <> 0) then

Line 1018: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1014: prog_id => prog_id,
1015: req_id => req_id,
1016: trans_id => c1rec.TI,
1017: error_text => err_text,
1018: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1019: msg_name => 'BOM_COMP_ID_MISSING',
1020: err_text => err_text);
1021: update bom_inventory_comps_interface set
1022: process_flag = 3

Line 1021: update bom_inventory_comps_interface set

1017: error_text => err_text,
1018: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1019: msg_name => 'BOM_COMP_ID_MISSING',
1020: err_text => err_text);
1021: update bom_inventory_comps_interface set
1022: process_flag = 3
1023: where transaction_id = c1rec.TI;
1024:
1025: if (ret_code <> 0) then

Line 1051: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1047: prog_id => prog_id,
1048: req_id => req_id,
1049: trans_id => c1rec.TI,
1050: error_text => err_text,
1051: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1052: msg_name => 'BOM_COMP_ID_MISSING',
1053: err_text => err_text);
1054: update bom_inventory_comps_interface set
1055: process_flag = 3

Line 1054: update bom_inventory_comps_interface set

1050: error_text => err_text,
1051: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1052: msg_name => 'BOM_COMP_ID_MISSING',
1053: err_text => err_text);
1054: update bom_inventory_comps_interface set
1055: process_flag = 3
1056: where transaction_id = c1rec.TI;
1057:
1058: if (ret_code <> 0) then

Line 1070: update bom_inventory_comps_interface set

1066: END;
1067: END;
1068: <>
1069:
1070: update bom_inventory_comps_interface set
1071: component_item_id = nvl(component_item_id, c1rec.CII),
1072: item_num = nvl(item_num, 1),
1073: component_quantity = nvl(component_quantity, 1),
1074: component_yield_factor = nvl(component_yield_factor, 1),

Line 1267: from bom_inventory_comps_interface

1263: END;
1264:
1265: select component_sequence_id
1266: into cmp_seq_id
1267: from bom_inventory_comps_interface
1268: where bill_sequence_id = bill_seq_id
1269: and component_item_id = cmp_id
1270: and operation_seq_num = op_seq
1271: and to_char(effectivity_date,'YYYY/MM/DD HH24:MI') = eff_date

Line 1362: BOM_INVENTORY_COMPS_INTERFACE

1358: REQUIRES
1359: err_text out buffer to return error message
1360: MODIFIES
1361: BOM_BILL_OF_MTLS_INTERFACE
1362: BOM_INVENTORY_COMPS_INTERFACE
1363: BOM_REF_DESGS_INTERFACE
1364: BOM_SUB_COMPS_INTERFACE
1365: MTL_INTERFACE_ERRORS
1366: RETURNS

Line 1382: From bom_inventory_comps_interface bici

1378:
1379: IS
1380: Cursor GetComps is
1381: Select bici.rowid row_id
1382: From bom_inventory_comps_interface bici
1383: where bici.process_flag = 1
1384: and bici.assembly_item_id is null
1385: and bici.organization_id = org_id
1386: and bici.assembly_item_number = item_number

Line 1406: update bom_inventory_comps_interface

1402: and bsc.assembly_item_number = item_number
1403: and bsc.bill_sequence_id is null;
1404: BEGIN
1405: For X_Component in GetComps loop
1406: update bom_inventory_comps_interface
1407: set assembly_item_id = item_id
1408: where rowid = X_Component.row_id;
1409: if mod(GetComps%rowcount, 500) = 0 then
1410: commit;

Line 1478: update bom_inventory_comps_interface set

1474: IS
1475: stmt_num NUMBER := 1;
1476: BEGIN
1477: loop
1478: update bom_inventory_comps_interface set
1479: bill_sequence_id = bom_id
1480: where process_flag = 1
1481: and organization_id = org_id
1482: and assembly_item_id = assy_id

Line 1648: from bom_inventory_comps_interface

1644: END;
1645:
1646: select component_quantity
1647: into comp_qty
1648: from bom_inventory_comps_interface
1649: where component_sequence_id = comp_seq_id
1650: and process_flag <> 3 and process_flag <> 7
1651: and rownum = 1;
1652:

Line 1765: from bom_inventory_comps_interface

1761: NVL(PROGRAM_ID, prog_id),
1762: NVL(PROGRAM_UPDATE_DATE, sysdate),
1763: COMPONENT_SEQUENCE_ID,
1764: 1
1765: from bom_inventory_comps_interface
1766: where process_flag = 2
1767: and reference_designator is not null;
1768:
1769: commit;

Line 2199: from bom_inventory_comps_interface

2195: NVL(PROGRAM_UPDATE_DATE, sysdate),
2196: COMPONENT_SEQUENCE_ID,
2197: 1,
2198: COMPONENT_QUANTITY
2199: from bom_inventory_comps_interface
2200: where process_flag = 2
2201: and (substitute_comp_id is not null
2202: or
2203: substitute_comp_number is not null);