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 1531: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599

1527: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1528: n IN BINARY_INTEGER
1529: ) IS -- bug 608353
1530: x_progress VARCHAR2(3);
1531: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1532: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1533: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1534: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1535: x_item_id_po po_lines.item_id%TYPE := NULL;

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

1528: n IN BINARY_INTEGER
1529: ) IS -- bug 608353
1530: x_progress VARCHAR2(3);
1531: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1532: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1533: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1534: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1535: x_item_id_po po_lines.item_id%TYPE := NULL;
1536: x_error_status VARCHAR2(1);

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

1529: ) IS -- bug 608353
1530: x_progress VARCHAR2(3);
1531: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1532: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1533: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1534: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1535: x_item_id_po po_lines.item_id%TYPE := NULL;
1536: x_error_status VARCHAR2(1);
1537: BEGIN

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

1530: x_progress VARCHAR2(3);
1531: l_stock_enabled_flag mtl_system_items.stock_enabled_flag%TYPE; -- Bugfix 5735599
1532: l_inventory_item_flag mtl_system_items.inventory_item_flag%TYPE; -- Bugfix 5735599
1533: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1534: x_organization_id mtl_system_items.organization_id%TYPE := NULL;
1535: x_item_id_po po_lines.item_id%TYPE := NULL;
1536: x_error_status VARCHAR2(1);
1537: BEGIN
1538: asn_debug.put_line('inside validate item : receipt_source_code = ' || x_cascaded_table(n).receipt_source_code);

Line 1543: FROM mtl_system_items

1539: x_error_status := rcv_error_pkg.g_ret_sts_error;
1540:
1541: SELECT NVL(MAX(inventory_item_id), -9999)
1542: INTO x_inventory_item
1543: FROM mtl_system_items
1544: WHERE inventory_item_id = x_cascaded_table(n).item_id;
1545:
1546: IF (x_inventory_item = -9999) THEN
1547: rcv_error_pkg.set_error_message('RCV_ITEM_ID');

Line 1553: FROM mtl_system_items

1549: END IF;
1550:
1551: SELECT NVL(MAX(inventory_item_id), -9999)
1552: INTO x_inventory_item
1553: FROM mtl_system_items
1554: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
1555: AND inventory_item_id = x_cascaded_table(n).item_id
1556: AND organization_id = NVL(x_cascaded_table(n).to_organization_id,organization_id); -- Bug 12985791
1557:

Line 1579: FROM mtl_system_items

1575: SELECT stock_enabled_flag,
1576: inventory_item_flag
1577: INTO l_stock_enabled_flag,
1578: l_inventory_item_flag
1579: FROM mtl_system_items
1580: WHERE organization_id = x_cascaded_table(n).to_organization_id
1581: AND inventory_item_id = x_cascaded_table(n).item_id;
1582: EXCEPTION
1583: WHEN OTHERS

Line 1619: FROM mtl_system_items

1615: * check for nvl(max(item_id),0).
1616: */
1617: SELECT NVL(MAX(organization_id), -9999)
1618: INTO x_organization_id
1619: FROM mtl_system_items
1620: WHERE inventory_item_id = x_cascaded_table(n).item_id
1621: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1622:
1623: IF (x_organization_id = -9999) THEN

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

1680: PROCEDURE validate_substitute_item(
1681: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1682: n IN BINARY_INTEGER
1683: ) IS
1684: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1685: x_progress VARCHAR2(3);
1686: x_vendor_id po_vendors.vendor_id%TYPE := NULL;
1687: x_error_status VARCHAR2(1);
1688: x_allow_sub_flag VARCHAR2(1);

Line 1694: FROM mtl_system_items

1690: x_error_status := rcv_error_pkg.g_ret_sts_error;
1691:
1692: SELECT NVL(MAX(inventory_item_id), 0)
1693: INTO x_inventory_item
1694: FROM mtl_system_items
1695: WHERE inventory_item_id = x_cascaded_table(n).substitute_item_id
1696: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1697:
1698: IF (x_inventory_item = 0) THEN

Line 1705: FROM mtl_system_items

1701: END IF;
1702:
1703: SELECT NVL(MAX(inventory_item_id), 0)
1704: INTO x_inventory_item
1705: FROM mtl_system_items
1706: WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE - 1) AND NVL(end_date_active, SYSDATE + 1)
1707: AND inventory_item_id = x_cascaded_table(n).substitute_item_id
1708: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1709:

Line 1723: FROM mtl_system_items

1719: --the MIN gives No a priority over Yes, and the NVL covers the case where they are both null
1720: /* SELECT NVL(MIN(allow_substitute_receipts_flag),'N')
1721: INTO x_allow_sub_flag
1722: FROM (SELECT allow_substitute_receipts_flag
1723: FROM mtl_system_items
1724: WHERE inventory_item_id = (SELECT item_id
1725: FROM po_lines
1726: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1727: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id)

Line 1749: FROM mtl_system_items

1745: END IF;
1746:
1747: SELECT NVL(MAX(inventory_item_id), 0)
1748: INTO x_inventory_item
1749: FROM mtl_system_items
1750: WHERE inventory_item_id = x_cascaded_table(n).substitute_item_id
1751: AND organization_id = NVL(x_cascaded_table(n).to_organization_id, organization_id);
1752:
1753: IF (x_inventory_item = 0) THEN

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

1858: PROCEDURE validate_item_revision(
1859: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
1860: n IN BINARY_INTEGER
1861: ) IS
1862: x_inventory_item mtl_system_items.inventory_item_id%TYPE := NULL;
1863: x_progress VARCHAR2(3);
1864: x_revision_control_flag VARCHAR2(1);
1865: x_item_revision po_lines.item_revision%TYPE;
1866: x_error_status VARCHAR2(1);

Line 1904: FROM mtl_system_items msi

1900: 2, 'Y',
1901: 'N'
1902: )
1903: INTO x_revision_control_flag
1904: FROM mtl_system_items msi
1905: WHERE inventory_item_id = l_active_item_id
1906: AND organization_id = x_cascaded_table(n).to_organization_id;
1907:
1908: IF x_revision_control_flag = 'N' THEN --BUG: 5975270