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

Line 885: from bom_inventory_comps_interface bic

881: end if;
882:
883: select count(*)
884: into cnt
885: from bom_inventory_comps_interface bic
886: where bill_sequence_id = cmn_bom_id
887: and process_flag in (2, 4)
888: and NOT EXISTS
889: (SELECT 'x'

Line 958: from bom_inventory_comps_interface bic,

954: end if;
955:
956: select count(*) /* Comp and sub comp in interface */
957: into cnt
958: from bom_inventory_comps_interface bic,
959: bom_sub_comps_interface bsc
960: where bic.bill_sequence_id = cmn_bom_id
961: and bic.process_flag in (2, 4)
962: and bsc.process_flag in (2, 4)

Line 1111: bom_inventory_comps_interface ici

1107: msia.atp_components_flag ACF,
1108: msic.ato_forecast_control AFC
1109: from mtl_system_items msic,
1110: mtl_system_items msia,
1111: bom_inventory_comps_interface ici
1112: where process_flag = 2
1113: and msic.organization_id = ici.organization_id
1114: and msia.organization_id = ici.organization_id
1115: and msic.inventory_item_id = ici.component_item_id

Line 1139: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1135: prog_id => prog_id,
1136: req_id => request_id,
1137: trans_id => c1rec.TI,
1138: error_text => err_text,
1139: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1140: msg_name => 'BOM_COMP_SEQ_ID_DUPLICATE',
1141: err_text => err_text);
1142: update bom_inventory_comps_interface set
1143: process_flag = 3

Line 1142: update bom_inventory_comps_interface set

1138: error_text => err_text,
1139: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1140: msg_name => 'BOM_COMP_SEQ_ID_DUPLICATE',
1141: err_text => err_text);
1142: update bom_inventory_comps_interface set
1143: process_flag = 3
1144: where transaction_id = c1rec.TI;
1145:
1146: if (ret_code <> 0) then

Line 1171: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1167: prog_id => prog_id,
1168: req_id => request_id,
1169: trans_id => c1rec.TI,
1170: error_text => err_text,
1171: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1172: msg_name => 'BOM_COMPONENT_DUPLICATE',
1173: err_text => err_text);
1174: update bom_inventory_comps_interface set
1175: process_flag = 3

Line 1174: update bom_inventory_comps_interface set

1170: error_text => err_text,
1171: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1172: msg_name => 'BOM_COMPONENT_DUPLICATE',
1173: err_text => err_text);
1174: update bom_inventory_comps_interface set
1175: process_flag = 3
1176: where transaction_id = c1rec.TI;
1177:
1178: if (ret_code <> 0) then

Line 1201: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1197: prog_id => prog_id,
1198: req_id => request_id,
1199: trans_id => c1rec.TI,
1200: error_text => err_text,
1201: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1202: msg_name => 'BOM_BILL_SEQ_MISSING',
1203: err_text => err_text);
1204: update bom_inventory_comps_interface set
1205: process_flag = 3

Line 1204: update bom_inventory_comps_interface set

1200: error_text => err_text,
1201: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1202: msg_name => 'BOM_BILL_SEQ_MISSING',
1203: err_text => err_text);
1204: update bom_inventory_comps_interface set
1205: process_flag = 3
1206: where transaction_id = c1rec.TI;
1207:
1208: if (ret_code <> 0) then

Line 1235: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1231: prog_id => prog_id,
1232: req_id => request_id,
1233: trans_id => c1rec.TI,
1234: error_text => err_text,
1235: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1236: msg_name => 'BOM_IMPL_COMP_OVERLAP',
1237: err_text => err_text);
1238: update bom_inventory_comps_interface set
1239: process_flag = 3

Line 1238: update bom_inventory_comps_interface set

1234: error_text => err_text,
1235: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1236: msg_name => 'BOM_IMPL_COMP_OVERLAP',
1237: err_text => err_text);
1238: update bom_inventory_comps_interface set
1239: process_flag = 3
1240: where transaction_id = c1rec.TI;
1241:
1242: if (ret_code <> 0) then

Line 1269: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1265: prog_id => prog_id,
1266: req_id => request_id,
1267: trans_id => c1rec.TI,
1268: error_text => err_text,
1269: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1270: msg_name => 'BOM_COMMON_COMP',
1271: err_text => err_text);
1272: update bom_inventory_comps_interface set
1273: process_flag = 3

Line 1272: update bom_inventory_comps_interface set

1268: error_text => err_text,
1269: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1270: msg_name => 'BOM_COMMON_COMP',
1271: err_text => err_text);
1272: update bom_inventory_comps_interface set
1273: process_flag = 3
1274: where transaction_id = c1rec.TI;
1275:
1276: if (ret_code <> 0) then

Line 1301: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1297: prog_id => prog_id,
1298: req_id => request_id,
1299: trans_id => c1rec.TI,
1300: error_text => err_text,
1301: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1302: msg_name => 'BOM_COMMON_COMP',
1303: err_text => err_text);
1304: update bom_inventory_comps_interface set
1305: process_flag = 3

Line 1304: update bom_inventory_comps_interface set

1300: error_text => err_text,
1301: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1302: msg_name => 'BOM_COMMON_COMP',
1303: err_text => err_text);
1304: update bom_inventory_comps_interface set
1305: process_flag = 3
1306: where transaction_id = c1rec.TI;
1307:
1308: if (ret_code <> 0) then

Line 1361: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1357: prog_id => prog_id,
1358: req_id => request_id,
1359: trans_id => c1rec.TI,
1360: error_text => err_text,
1361: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1362: msg_name => 'BOM_INVALID_ITEM_ATTRIBUTES',
1363: err_text => err_text);
1364: update bom_inventory_comps_interface set
1365: process_flag = 3

Line 1364: update bom_inventory_comps_interface set

1360: error_text => err_text,
1361: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1362: msg_name => 'BOM_INVALID_ITEM_ATTRIBUTES',
1363: err_text => err_text);
1364: update bom_inventory_comps_interface set
1365: process_flag = 3
1366: where transaction_id = c1rec.TI;
1367:
1368: if (ret_code <> 0) then

Line 1394: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1390: prog_id => prog_id,
1391: req_id => request_id,
1392: trans_id => c1rec.TI,
1393: error_text => err_text,
1394: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1395: msg_name => 'BOM_INVALID_OP_SEQ',
1396: err_text => err_text);
1397: update bom_inventory_comps_interface set
1398: process_flag = 3

Line 1397: update bom_inventory_comps_interface set

1393: error_text => err_text,
1394: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1395: msg_name => 'BOM_INVALID_OP_SEQ',
1396: err_text => err_text);
1397: update bom_inventory_comps_interface set
1398: process_flag = 3
1399: where transaction_id = c1rec.TI;
1400:
1401: if (ret_code <> 0) then

Line 1421: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1417: prog_id => prog_id,
1418: req_id => request_id,
1419: trans_id => c1rec.TI,
1420: error_text => err_text,
1421: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1422: msg_name => 'BOM_EFFECTIVE_DATE_ERR',
1423: err_text => err_text);
1424: update bom_inventory_comps_interface set
1425: process_flag = 3

Line 1424: update bom_inventory_comps_interface set

1420: error_text => err_text,
1421: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1422: msg_name => 'BOM_EFFECTIVE_DATE_ERR',
1423: err_text => err_text);
1424: update bom_inventory_comps_interface set
1425: process_flag = 3
1426: where transaction_id = c1rec.TI;
1427:
1428: if (ret_code <> 0) then

Line 1460: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1456: prog_id => prog_id,
1457: req_id => request_id,
1458: trans_id => c1rec.TI,
1459: error_text => err_text,
1460: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1461: msg_name => 'BOM_PLANNING_FACTOR_ERR',
1462: err_text => err_text);
1463: update bom_inventory_comps_interface set
1464: process_flag = 3

Line 1463: update bom_inventory_comps_interface set

1459: error_text => err_text,
1460: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1461: msg_name => 'BOM_PLANNING_FACTOR_ERR',
1462: err_text => err_text);
1463: update bom_inventory_comps_interface set
1464: process_flag = 3
1465: where transaction_id = c1rec.TI;
1466:
1467: if (ret_code <> 0) then

Line 1489: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1485: prog_id => prog_id,
1486: req_id => request_id,
1487: trans_id => c1rec.TI,
1488: error_text => err_text,
1489: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1490: msg_name => 'BOM_OPTIONAL_ERR',
1491: err_text => err_text);
1492: update bom_inventory_comps_interface set
1493: process_flag = 3

Line 1492: update bom_inventory_comps_interface set

1488: error_text => err_text,
1489: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1490: msg_name => 'BOM_OPTIONAL_ERR',
1491: err_text => err_text);
1492: update bom_inventory_comps_interface set
1493: process_flag = 3
1494: where transaction_id = c1rec.TI;
1495:
1496: if (ret_code <> 0) then

Line 1508: update bom_inventory_comps_interface

1504: ** yield must be 1 and order entry values should be defaulted
1505: */
1506: stmt_num := 12;
1507: if (c1rec.BITA = 3) then
1508: update bom_inventory_comps_interface
1509: set component_yield_factor = 1,
1510: check_atp = 2,
1511: include_on_ship_docs = 2,
1512: so_basis = 2,

Line 1645: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1641: prog_id => prog_id,
1642: req_id => request_id,
1643: trans_id => c1rec.TI,
1644: error_text => err_text,
1645: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1646: msg_name => 'BOM_COMPONENT_ERROR',
1647: err_text => err_text);
1648: update bom_inventory_comps_interface set
1649: process_flag = 3

Line 1648: update bom_inventory_comps_interface set

1644: error_text => err_text,
1645: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1646: msg_name => 'BOM_COMPONENT_ERROR',
1647: err_text => err_text);
1648: update bom_inventory_comps_interface set
1649: process_flag = 3
1650: where transaction_id = c1rec.TI;
1651:
1652: if (ret_code <> 0) then

Line 1966: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1962: prog_id => prog_id,
1963: req_id => request_id,
1964: trans_id => c1rec.TI,
1965: error_text => err_text,
1966: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1967: msg_name => 'BOM_LOCATOR_INVALID',
1968: err_text => err_text);
1969: update bom_inventory_comps_interface set
1970: process_flag = 3

Line 1969: update bom_inventory_comps_interface set

1965: error_text => err_text,
1966: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1967: msg_name => 'BOM_LOCATOR_INVALID',
1968: err_text => err_text);
1969: update bom_inventory_comps_interface set
1970: process_flag = 3
1971: where transaction_id = c1rec.TI;
1972:
1973: if (ret_code <> 0) then

Line 1987: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1983: prog_id => prog_id,
1984: req_id => request_id,
1985: trans_id => c1rec.TI,
1986: error_text => err_text,
1987: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1988: msg_name => 'BOM_SUBINV_INVALID',
1989: err_text => err_text);
1990: update bom_inventory_comps_interface set
1991: process_flag = 3

Line 1990: update bom_inventory_comps_interface set

1986: error_text => err_text,
1987: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1988: msg_name => 'BOM_SUBINV_INVALID',
1989: err_text => err_text);
1990: update bom_inventory_comps_interface set
1991: process_flag = 3
1992: where transaction_id = c1rec.TI;
1993:
1994: if (ret_code <> 0) then

Line 1999: update bom_inventory_comps_interface

1995: raise ret_code_error;
1996: end if;
1997:
1998: when update_comp then
1999: update bom_inventory_comps_interface
2000: set process_flag = 4
2001: where transaction_id = c1rec.TI;
2002:
2003: when continue_loop then

Line 2277: from bom_inventory_comps_interface

2273: end if;
2274:
2275: select count(*)
2276: into dummy
2277: from bom_inventory_comps_interface
2278: where bill_sequence_id = bom_id
2279: and process_flag = 4
2280: and component_item_id = cmp_id
2281: and operation_seq_num = op_num

Line 2362: from bom_inventory_comps_interface

2358: ** check in interface table
2359: */
2360: select count(*)
2361: into dummy
2362: from bom_inventory_comps_interface
2363: where component_sequence_id = cmp_seq_id
2364: and process_flag = 4;
2365:
2366: if (dummy = 0) then

Line 2450: from bom_inventory_comps_interface

2446:
2447: begin
2448: select component_sequence_id
2449: into cnt
2450: from bom_inventory_comps_interface
2451: where bill_sequence_id = bill_seq_id
2452: and to_char(effectivity_date,'YYYY/MM/DD HH24:MI') = eff_date
2453: and component_item_id = cmp_item_id
2454: and operation_seq_num = op_seq

Line 2682: from bom_inventory_comps_interface bic,

2678: begin
2679: select bbom.organization_id,
2680: bbom.assembly_item_id, bic.bom_item_type
2681: into org_id_dummy, assy_id_dummy, comp_type
2682: from bom_inventory_comps_interface bic,
2683: bom_bill_of_mtls_interface bbom
2684: where component_sequence_id = c1rec.CSI
2685: and bic.process_flag = 4
2686: and bbom.process_flag = 4

Line 2698: from bom_inventory_comps_interface bic,

2694: begin
2695: select bbom.organization_id,
2696: bbom.assembly_item_id, bic.bom_item_type
2697: into org_id_dummy, assy_id_dummy, comp_type
2698: from bom_inventory_comps_interface bic,
2699: bom_bill_of_materials bbom
2700: where component_sequence_id = c1rec.CSI
2701: and bic.process_flag = 4
2702: and bbom.bill_sequence_id = bic.bill_sequence_id;

Line 2928: from bom_inventory_comps_interface

2924: */
2925: if (qty_flag <> 1 and qty_flag <> 2) then
2926: select QUANTITY_RELATED, COMPONENT_QUANTITY
2927: into qty_flag, cmp_qty
2928: from bom_inventory_comps_interface
2929: where component_sequence_id = cmp_seq_id
2930: and process_flag = 4;
2931: end if;
2932:

Line 3079: from bom_inventory_comps_interface bic,

3075: bbom.assembly_type, bic.component_item_id,
3076: bic.bom_item_type
3077: into assy_id_dummy, org_id_dummy,assy_type_dummy,
3078: comp_id_dummy, comp_type
3079: from bom_inventory_comps_interface bic,
3080: bom_bill_of_mtls_interface bbom
3081: where component_sequence_id = c1rec.CSI
3082: and bic.process_flag = 4
3083: and bbom.process_flag = 4

Line 3097: from bom_inventory_comps_interface bic,

3093: bbom.assembly_type, bic.component_item_id,
3094: bic.bom_item_type
3095: into assy_id_dummy, org_id_dummy,assy_type_dummy,
3096: comp_id_dummy, comp_type
3097: from bom_inventory_comps_interface bic,
3098: bom_bill_of_materials bbom
3099: where component_sequence_id = c1rec.CSI
3100: and bic.process_flag = 4
3101: and bbom.bill_sequence_id = bic.bill_sequence_id;