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.BOMPVALR dependencies on BOM_OP_RESOURCES_INTERFACE

Line 1145: from bom_op_resources_interface

1141: IS
1142: cursor c1 is
1143: select operation_sequence_id OSI, transaction_id TI,
1144: organization_id OI
1145: from bom_op_resources_interface
1146: where process_flag = 2
1147: and rownum < 500
1148: group by transaction_id, operation_sequence_id, organization_id;
1149:

Line 1170: from bom_op_resources_interface

1166: ** check for null resource seq num
1167: */
1168: select count(distinct operation_sequence_id)
1169: into total_recs
1170: from bom_op_resources_interface
1171: where process_flag = 2;
1172:
1173: continue_loop := TRUE;
1174: commit_cnt := 0;

Line 1181: from bom_op_resources_interface

1177: for c1rec in c1 loop
1178: commit_cnt := commit_cnt + 1;
1179: select count(*)
1180: into dummy
1181: from bom_op_resources_interface
1182: where transaction_id = c1rec.TI
1183: and resource_seq_num is null;
1184:
1185: if (dummy = 0) then

Line 1197: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1193: prog_id => prog_id,
1194: req_id => request_id,
1195: trans_id => c1rec.TI,
1196: error_text => err_text,
1197: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1198: msg_name => 'BOM_NULL_RESOURCE_SEQ_NUM',
1199: err_text => err_text);
1200: update bom_op_resources_interface set
1201: process_flag = 3

Line 1200: update bom_op_resources_interface set

1196: error_text => err_text,
1197: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1198: msg_name => 'BOM_NULL_RESOURCE_SEQ_NUM',
1199: err_text => err_text);
1200: update bom_op_resources_interface set
1201: process_flag = 3
1202: where transaction_id = c1rec.TI;
1203:
1204: if (ret_code <> 0) then

Line 1227: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1223: prog_id => prog_id,
1224: req_id => request_id,
1225: trans_id => c1rec.TI,
1226: error_text => err_text,
1227: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1228: msg_name => 'BOM_OP_SEQ_INVALID',
1229: err_text => err_text);
1230: update bom_op_resources_interface set
1231: process_flag = 3

Line 1230: update bom_op_resources_interface set

1226: error_text => err_text,
1227: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1228: msg_name => 'BOM_OP_SEQ_INVALID',
1229: err_text => err_text);
1230: update bom_op_resources_interface set
1231: process_flag = 3
1232: where transaction_id = c1rec.TI;
1233:
1234: if (ret_code <> 0) then

Line 1266: from bom_op_resources_interface ori

1262: ** validate resource exists and is enabled and belongs to dept
1263: */
1264: select count(*)
1265: into res_cnt
1266: from bom_op_resources_interface ori
1267: where ori.operation_sequence_id = c1rec.OSI
1268: and ori.resource_id not in (select br.resource_id
1269: from bom_Resources br, bom_department_resources bdr
1270: where br.resource_id = ori.resource_id

Line 1284: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1280: prog_id => prog_id,
1281: req_id => request_id,
1282: trans_id => c1rec.TI,
1283: error_text => err_text,
1284: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1285: msg_name => 'BOM_DEPT_RES_INVALID',
1286: err_text => err_text);
1287: update bom_op_resources_interface set
1288: process_flag = 3

Line 1287: update bom_op_resources_interface set

1283: error_text => err_text,
1284: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1285: msg_name => 'BOM_DEPT_RES_INVALID',
1286: err_text => err_text);
1287: update bom_op_resources_interface set
1288: process_flag = 3
1289: where transaction_id = c1rec.TI;
1290:
1291: if (ret_code <> 0) then

Line 1302: from bom_op_resources_interface ori

1298: ** verify activity is enabled
1299: */
1300: select count(*)
1301: into res_cnt
1302: from bom_op_resources_interface ori
1303: where operation_Sequence_id = c1rec.OSI
1304: and activity_id is not null
1305: and activity_id not in (select activity_id
1306: from cst_activities ca

Line 1321: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1317: prog_id => prog_id,
1318: req_id => request_id,
1319: trans_id => c1rec.TI,
1320: error_text => err_text,
1321: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1322: msg_name => 'BOM_ACTIVITY_ID_INVALID',
1323: err_text => err_text);
1324: update bom_op_resources_interface set
1325: process_flag = 3

Line 1324: update bom_op_resources_interface set

1320: error_text => err_text,
1321: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1322: msg_name => 'BOM_ACTIVITY_ID_INVALID',
1323: err_text => err_text);
1324: update bom_op_resources_interface set
1325: process_flag = 3
1326: where transaction_id = c1rec.TI;
1327:
1328: if (ret_code <> 0) then

Line 1349: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1345: prog_id => prog_id,
1346: req_id => request_id,
1347: trans_id => c1rec.TI,
1348: error_text => err_text,
1349: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1350: msg_name => 'BOM_DUPLICATE_RES_NUM',
1351: err_text => err_text);
1352: update bom_op_resources_interface set
1353: process_flag = 3

Line 1352: update bom_op_resources_interface set

1348: error_text => err_text,
1349: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1350: msg_name => 'BOM_DUPLICATE_RES_NUM',
1351: err_text => err_text);
1352: update bom_op_resources_interface set
1353: process_flag = 3
1354: where transaction_id = c1rec.TI;
1355:
1356: if (ret_code <> 0) then

Line 1403: from bom_op_resources_interface ori, bom_resources br,

1399: and ood.set_of_books_id = gsb.set_of_books_id;
1400:
1401: select count(*)
1402: into res_cnt
1403: from bom_op_resources_interface ori, bom_resources br,
1404: mtl_units_of_measure uom
1405: where ori.operation_sequence_id = c1rec.OSI
1406: and ori.schedule_flag = 1
1407: and ori.resource_id = br.resource_id

Line 1435: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1431: prog_id => prog_id,
1432: req_id => request_id,
1433: trans_id => c1rec.TI,
1434: error_text => err_text,
1435: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1436: msg_name => 'BOM_OP_RES_SCHED_NO',
1437: err_text => err_text);
1438: update bom_op_resources_interface set
1439: process_flag = 3

Line 1438: update bom_op_resources_interface set

1434: error_text => err_text,
1435: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1436: msg_name => 'BOM_OP_RES_SCHED_NO',
1437: err_text => err_text);
1438: update bom_op_resources_interface set
1439: process_flag = 3
1440: where transaction_id = c1rec.TI;
1441:
1442: if (ret_code <> 0) then

Line 1466: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1462: prog_id => prog_id,
1463: req_id => request_id,
1464: trans_id => c1rec.TI,
1465: error_text => err_text,
1466: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1467: msg_name => 'BOM_OP_RES_PRIOR_ERROR',
1468: err_text => err_text);
1469: update bom_op_resources_interface set
1470: process_flag = 3

Line 1469: update bom_op_resources_interface set

1465: error_text => err_text,
1466: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1467: msg_name => 'BOM_OP_RES_PRIOR_ERROR',
1468: err_text => err_text);
1469: update bom_op_resources_interface set
1470: process_flag = 3
1471: where transaction_id = c1rec.TI;
1472:
1473: if (ret_code <> 0) then

Line 1493: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1489: prog_id => prog_id,
1490: req_id => request_id,
1491: trans_id => c1rec.TI,
1492: error_text => err_text,
1493: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1494: msg_name => 'BOM_OP_RES_NEXT_ERROR',
1495: err_text => err_text);
1496: update bom_op_resources_interface set
1497: process_flag = 3

Line 1496: update bom_op_resources_interface set

1492: error_text => err_text,
1493: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1494: msg_name => 'BOM_OP_RES_NEXT_ERROR',
1495: err_text => err_text);
1496: update bom_op_resources_interface set
1497: process_flag = 3
1498: where transaction_id = c1rec.TI;
1499:
1500: if (ret_code <> 0) then

Line 1512: from bom_op_resources_interface bori

1508: ** 1) autocharge_type = 3 or 4 2) res uom class = hour_uom_class
1509: */
1510: select count(*)
1511: into res_cnt
1512: from bom_op_resources_interface bori
1513: where operation_sequence_id = c1rec.OSI
1514: and process_flag <> 3 and process_flag <> 7
1515: and usage_rate_or_amount < 0
1516: and (autocharge_type in (3,4)

Line 1535: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1531: prog_id => prog_id,
1532: req_id => request_id,
1533: trans_id => c1rec.TI,
1534: error_text => err_text,
1535: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1536: msg_name => 'BOM_NEGATIVE_USAGE_RATE',
1537: err_text => err_text);
1538: update bom_op_resources_interface set
1539: process_flag = 3

Line 1538: update bom_op_resources_interface set

1534: error_text => err_text,
1535: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1536: msg_name => 'BOM_NEGATIVE_USAGE_RATE',
1537: err_text => err_text);
1538: update bom_op_resources_interface set
1539: process_flag = 3
1540: where transaction_id = c1rec.TI;
1541:
1542: if (ret_code <> 0) then

Line 1555: from bom_op_resources_interface ori

1551: ** (verified in ASSIGN)
1552: */
1553: select count(*)
1554: into res_cnt
1555: from bom_op_resources_interface ori
1556: where operation_sequence_id = c1rec.OSI
1557: and assigned_units <= .00001;
1558:
1559: if (res_cnt <> 0) then

Line 1569: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1565: prog_id => prog_id,
1566: req_id => request_id,
1567: trans_id => c1rec.TI,
1568: error_text => err_text,
1569: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1570: msg_name => 'BOM_ASSIGNED_UNIT_ERROR',
1571: err_text => err_text);
1572: update bom_op_resources_interface set
1573: process_flag = 3

Line 1572: update bom_op_resources_interface set

1568: error_text => err_text,
1569: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1570: msg_name => 'BOM_ASSIGNED_UNIT_ERROR',
1571: err_text => err_text);
1572: update bom_op_resources_interface set
1573: process_flag = 3
1574: where transaction_id = c1rec.TI;
1575:
1576: if (ret_code <> 0) then

Line 1588: from bom_op_resources_interface ori

1584: ** and autocharge type are valid
1585: */
1586: select count(*)
1587: into res_cnt
1588: from bom_op_resources_interface ori
1589: where operation_sequence_id = c1rec.OSI
1590: and ( (basis_type not in (1,2))
1591: or
1592: (standard_rate_flag not in (1, 2))

Line 1608: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1604: prog_id => prog_id,
1605: req_id => request_id,
1606: trans_id => c1rec.TI,
1607: error_text => err_text,
1608: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1609: msg_name => 'BOM_OP_RES_LOOKUP_ERROR',
1610: err_text => err_text);
1611: update bom_op_resources_interface set
1612: process_flag = 3

Line 1611: update bom_op_resources_interface set

1607: error_text => err_text,
1608: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1609: msg_name => 'BOM_OP_RES_LOOKUP_ERROR',
1610: err_text => err_text);
1611: update bom_op_resources_interface set
1612: process_flag = 3
1613: where transaction_id = c1rec.TI;
1614:
1615: if (ret_code <> 0) then

Line 1639: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1635: prog_id => prog_id,
1636: req_id => request_id,
1637: trans_id => c1rec.TI,
1638: error_text => err_text,
1639: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1640: msg_name => 'BOM_AUTOCHARGE_INVALID',
1641: err_text => err_text);
1642: update bom_op_resources_interface set
1643: process_flag = 3

Line 1642: update bom_op_resources_interface set

1638: error_text => err_text,
1639: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1640: msg_name => 'BOM_AUTOCHARGE_INVALID',
1641: err_text => err_text);
1642: update bom_op_resources_interface set
1643: process_flag = 3
1644: where transaction_id = c1rec.TI;
1645:
1646: if (ret_code <> 0) then

Line 1655: from bom_op_resources_interface ori

1651:
1652: /* Check offset percent */
1653: select count(*)
1654: into res_cnt
1655: from bom_op_resources_interface ori
1656: where operation_sequence_id = c1rec.OSI
1657: and resource_offset_percent not between 0 and 100
1658: and resource_offset_percent is not null;
1659:

Line 1670: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1666: prog_id => prog_id,
1667: req_id => request_id,
1668: trans_id => c1rec.TI,
1669: error_text => err_text,
1670: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1671: msg_name => 'BOM_OFFSET_PERCENT_INVALID',
1672: err_text => err_text);
1673: update bom_op_resources_interface set
1674: process_flag = 3

Line 1673: update bom_op_resources_interface set

1669: error_text => err_text,
1670: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1671: msg_name => 'BOM_OFFSET_PERCENT_INVALID',
1672: err_text => err_text);
1673: update bom_op_resources_interface set
1674: process_flag = 3
1675: where transaction_id = c1rec.TI;
1676:
1677: if (ret_code <> 0) then

Line 1687: from bom_op_resources_interface ori

1683: ** Check usage rate and usage rate inverse -- Bug 7322996
1684: */
1685: select count(*)
1686: into res_cnt
1687: from bom_op_resources_interface ori
1688: where operation_sequence_id = c1rec.OSI
1689: and round(usage_rate_or_amount,G_round_off_val) <>
1690: decode(usage_rate_or_amount_inverse,0,0,
1691: round((1/usage_rate_or_amount_inverse),G_round_off_val)

Line 1704: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',

1700: prog_id => prog_id,
1701: req_id => request_id,
1702: trans_id => c1rec.TI,
1703: error_text => err_text,
1704: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1705: msg_name => 'BOM_USAGE_RATE_INVALID',
1706: err_text => err_text);
1707: update bom_op_resources_interface set
1708: process_flag = 3

Line 1707: update bom_op_resources_interface set

1703: error_text => err_text,
1704: tbl_name => 'BOM_OP_RESOURCES_INTERFACE',
1705: msg_name => 'BOM_USAGE_RATE_INVALID',
1706: err_text => err_text);
1707: update bom_op_resources_interface set
1708: process_flag = 3
1709: where transaction_id = c1rec.TI;
1710:
1711: if (ret_code <> 0) then

Line 1717: update bom_op_resources_interface

1713: end if;
1714: goto continue_loop;
1715: end if;
1716:
1717: update bom_op_resources_interface
1718: set process_flag = 4
1719: where transaction_id = c1rec.TI;
1720:
1721: <>

Line 1773: from bom_operation_resources a, bom_op_resources_interface b

1769: */
1770: begin
1771: select 1
1772: into dummy
1773: from bom_operation_resources a, bom_op_resources_interface b
1774: where b.transaction_id = trans_id
1775: and a.operation_sequence_id = b.operation_sequence_id
1776: and a.resource_seq_num =
1777: b.resource_seq_num

Line 1795: from bom_op_resources_interface a

1791: ** check in interface table
1792: */
1793: select count(*)
1794: into dummy
1795: from bom_op_resources_interface a
1796: where transaction_id = trans_id
1797: and exists (select 'same resource'
1798: from bom_op_resources_interface b
1799: where b.transaction_id = trans_id

Line 1798: from bom_op_resources_interface b

1794: into dummy
1795: from bom_op_resources_interface a
1796: where transaction_id = trans_id
1797: and exists (select 'same resource'
1798: from bom_op_resources_interface b
1799: where b.transaction_id = trans_id
1800: and b.rowid <> a.rowid
1801: and b.resource_seq_num =
1802: a.resource_seq_num

Line 2899: from bom_op_resources_interface

2895:
2896: BEGIN
2897: select count(*)
2898: into res_cnt
2899: from bom_op_resources_interface
2900: where operation_sequence_id = op_seq
2901: and schedule_flag = sched_type
2902: and process_flag <> 3 and process_flag <> 7;
2903:

Line 2963: from bom_op_resources_interface ori

2959: cnt NUMBER;
2960: BEGIN
2961: select count(*)
2962: into cnt
2963: from bom_op_resources_interface ori
2964: where operation_sequence_id = op_seq
2965: and autocharge_type in (3,4)
2966: and not exists (select 'no dept loc or res pur item'
2967: from bom_departments bd

Line 2978: from bom_op_resources_interface ori

2974: end if;
2975:
2976: select count(*)
2977: into cnt
2978: from bom_op_resources_interface ori
2979: where operation_sequence_id = op_seq
2980: and autocharge_type = 4
2981: and process_flag <> 3 and process_flag <> 7;
2982: if (cnt > 1) then