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.RCV_ROI_HEADER_COMMON dependencies on MTL_SYSTEM_ITEMS

Line 384: FROM mtl_system_items

380: --NVL(x_cascaded_table(n).use_mtl_serial, serial_number_control_code)
381: INTO x_cascaded_table(n).primary_unit_of_measure
382: --x_cascaded_table(n).use_mtl_lot,
383: --x_cascaded_table(n).use_mtl_serial
384: FROM mtl_system_items
385: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
386: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
387:
388: IF (g_asn_debug = 'Y') THEN

Line 385: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id

381: INTO x_cascaded_table(n).primary_unit_of_measure
382: --x_cascaded_table(n).use_mtl_lot,
383: --x_cascaded_table(n).use_mtl_serial
384: FROM mtl_system_items
385: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
386: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
387:
388: IF (g_asn_debug = 'Y') THEN
389: asn_debug.put_line('Primary UOM: ' || x_cascaded_table(n).primary_unit_of_measure);

Line 386: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;

382: --x_cascaded_table(n).use_mtl_lot,
383: --x_cascaded_table(n).use_mtl_serial
384: FROM mtl_system_items
385: WHERE mtl_system_items.inventory_item_id = x_cascaded_table(n).item_id
386: AND mtl_system_items.organization_id = x_cascaded_table(n).to_organization_id;
387:
388: IF (g_asn_debug = 'Y') THEN
389: asn_debug.put_line('Primary UOM: ' || x_cascaded_table(n).primary_unit_of_measure);
390: END IF;

Line 1441: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599

1437: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1438: n IN BINARY_INTEGER
1439: ) IS -- bug 608353
1440: x_progress VARCHAR2(3);
1441: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1442: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1443: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1444: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1445: x_item_id_po po_lines.item_id%TYPE := NULL;

Line 1442: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599

1438: n IN BINARY_INTEGER
1439: ) IS -- bug 608353
1440: x_progress VARCHAR2(3);
1441: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1442: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1443: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1444: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1445: x_item_id_po po_lines.item_id%TYPE := NULL;
1446: x_error_status VARCHAR2(1);

Line 1443: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;

1439: ) IS -- bug 608353
1440: x_progress VARCHAR2(3);
1441: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1442: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1443: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1444: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1445: x_item_id_po po_lines.item_id%TYPE := NULL;
1446: x_error_status VARCHAR2(1);
1447: BEGIN

Line 1444: x_organization_id mtl_system_items.organization_id%TYPE := NULL;

1440: x_progress VARCHAR2(3);
1441: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1442: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1443: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1444: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1445: x_item_id_po po_lines.item_id%TYPE := NULL;
1446: x_error_status VARCHAR2(1);
1447: BEGIN
1448: asn_debug.put_line('inside validate item : receipt_source_code = ' || x_cascaded_table(n).receipt_source_code);

Line 1453: FROM mtl_system_items

1449: x_error_status := rcv_error_pkg.g_ret_sts_error;
1450:
1451: SELECT NVL(MAX(inventory_item_id), -9999)
1452: INTO x_inventory_item
1453: FROM mtl_system_items
1454: WHERE inventory_item_id = x_cascaded_table(n).item_id;
1455:
1456: IF (x_inventory_item = -9999) THEN
1457: rcv_error_pkg.set_error_message('RCV_ITEM_ID');

Line 1463: FROM mtl_system_items

1459: END IF;
1460:
1461: SELECT NVL(MAX(inventory_item_id), -9999)
1462: INTO x_inventory_item
1463: FROM mtl_system_items
1464: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
1465: AND inventory_item_id = x_cascaded_table(n).item_id;
1466:
1467: IF (x_inventory_item = -9999) THEN

Line 1488: FROM mtl_system_items

1484: SELECT stock_enabled_flag,
1485: inventory_item_flag
1486: INTO l_stock_enabled_flag,
1487: l_inventory_item_flag
1488: FROM mtl_system_items
1489: WHERE organization_id = x_cascaded_table(n).to_organization_id
1490: AND inventory_item_id = x_cascaded_table(n).item_id;
1491: EXCEPTION
1492: WHEN OTHERS

Line 1527: FROM mtl_system_items

1523: * check for nvl(max(item_id),0).
1524: */
1525: SELECT NVL(MAX(organization_id), -9999)
1526: INTO x_organization_id
1527: FROM mtl_system_items
1528: WHERE inventory_item_id = x_cascaded_table(n).item_id
1529: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1530:
1531: IF (x_organization_id = -9999) THEN

Line 1592: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;

1588: PROCEDURE validate_substitute_item(
1589: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1590: n IN BINARY_INTEGER
1591: ) IS
1592: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1593: x_progress VARCHAR2(3);
1594: x_vendor_id po_vendors.vendor_id%TYPE := NULL;
1595: x_error_status VARCHAR2(1);
1596: x_allow_sub_flag VARCHAR2(1);

Line 1602: FROM mtl_system_items

1598: x_error_status := rcv_error_pkg.g_ret_sts_error;
1599:
1600: SELECT NVL(MAX(inventory_item_id), 0)
1601: INTO x_inventory_item
1602: FROM mtl_system_items
1603: WHERE inventory_item_id = x_cascaded_table(n).substitute_item_id
1604: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1605:
1606: IF (x_inventory_item = 0) THEN

Line 1613: FROM mtl_system_items

1609: END IF;
1610:
1611: SELECT NVL(MAX(inventory_item_id), 0)
1612: INTO x_inventory_item
1613: FROM mtl_system_items
1614: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
1615: AND inventory_item_id = x_cascaded_table(n).substitute_item_id
1616: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1617:

Line 1631: FROM mtl_system_items

1627: --the MIN gives No a priority over Yes, and the NVL covers the case where they are both null
1628: /* SELECT NVL(MIN(allow_substitute_receipts_flag),'N')
1629: INTO x_allow_sub_flag
1630: FROM (SELECT allow_substitute_receipts_flag
1631: FROM mtl_system_items
1632: WHERE inventory_item_id = (SELECT item_id
1633: FROM po_lines
1634: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1635: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)

Line 1646: FROM mtl_system_items msi,

1642:
1643: SELECT NVL(MIN(allow_substitute_receipts_flag),'N')
1644: INTO x_allow_sub_flag
1645: FROM (SELECT msi.allow_substitute_receipts_flag
1646: FROM mtl_system_items msi,
1647: po_lines_all pl
1648: WHERE msi.inventory_item_id = pl.item_id
1649: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1650: AND msi.organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)

Line 1662: FROM mtl_system_items

1658: END IF;
1659:
1660: SELECT NVL(MAX(inventory_item_id), 0)
1661: INTO x_inventory_item
1662: FROM mtl_system_items
1663: WHERE inventory_item_id = x_cascaded_table(n).substitute_item_id
1664: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1665:
1666: IF (x_inventory_item = 0) THEN

Line 1773: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;

1769: PROCEDURE validate_item_revision(
1770: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1771: n IN BINARY_INTEGER
1772: ) IS
1773: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1774: x_progress VARCHAR2(3);
1775: x_revision_control_flag VARCHAR2(1);
1776: x_item_revision po_lines.item_revision%TYPE;
1777: x_error_status VARCHAR2(1);

Line 1815: FROM mtl_system_items msi

1811: 2, 'Y',
1812: 'N'
1813: )
1814: INTO x_revision_control_flag
1815: FROM mtl_system_items msi
1816: WHERE inventory_item_id = l_active_item_id
1817: AND organization_id = x_cascaded_table(n).to_organization_id;
1818:
1819: IF x_revision_control_flag = 'N' THEN --BUG: 5975270