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

Line 1623: , mtl_system_items msi

1619: FROM rcv_transactions rt
1620: , rcv_supply rsup
1621: , rcv_shipment_headers rsh
1622: , rcv_shipment_lines rsl
1623: , mtl_system_items msi
1624: , po_lines pol
1625: , po_distributions pod
1626: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
1627: AND rsup.to_organization_id = p_organization_id

Line 1693: FROM mtl_system_items

1689:
1690: BEGIN
1691: SELECT primary_unit_of_measure
1692: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
1693: FROM mtl_system_items
1694: WHERE mtl_system_items.inventory_item_id = p_item_id
1695: AND mtl_system_items.organization_id = p_organization_id;
1696: EXCEPTION
1697: WHEN NO_DATA_FOUND THEN

Line 1694: WHERE mtl_system_items.inventory_item_id = p_item_id

1690: BEGIN
1691: SELECT primary_unit_of_measure
1692: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
1693: FROM mtl_system_items
1694: WHERE mtl_system_items.inventory_item_id = p_item_id
1695: AND mtl_system_items.organization_id = p_organization_id;
1696: EXCEPTION
1697: WHEN NO_DATA_FOUND THEN
1698: NULL;

Line 1695: AND mtl_system_items.organization_id = p_organization_id;

1691: SELECT primary_unit_of_measure
1692: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
1693: FROM mtl_system_items
1694: WHERE mtl_system_items.inventory_item_id = p_item_id
1695: AND mtl_system_items.organization_id = p_organization_id;
1696: EXCEPTION
1697: WHEN NO_DATA_FOUND THEN
1698: NULL;
1699: END;

Line 2004: , mtl_system_items msi

2000: FROM rcv_transactions rt
2001: , rcv_supply rsup
2002: , rcv_shipment_headers rsh
2003: , rcv_shipment_lines rsl
2004: , mtl_system_items msi
2005: , po_lines pol
2006: , po_distributions pod
2007: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
2008: AND rsup.to_organization_id = p_organization_id

Line 2204: FROM mtl_system_items

2200:
2201: BEGIN
2202: SELECT primary_unit_of_measure
2203: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2204: FROM mtl_system_items
2205: WHERE mtl_system_items.inventory_item_id = p_item_id
2206: AND mtl_system_items.organization_id = p_organization_id;
2207: EXCEPTION
2208: WHEN NO_DATA_FOUND THEN

Line 2205: WHERE mtl_system_items.inventory_item_id = p_item_id

2201: BEGIN
2202: SELECT primary_unit_of_measure
2203: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2204: FROM mtl_system_items
2205: WHERE mtl_system_items.inventory_item_id = p_item_id
2206: AND mtl_system_items.organization_id = p_organization_id;
2207: EXCEPTION
2208: WHEN NO_DATA_FOUND THEN
2209: --Bug5574012:In case of one time items,the UOM will be fetched from the

Line 2206: AND mtl_system_items.organization_id = p_organization_id;

2202: SELECT primary_unit_of_measure
2203: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2204: FROM mtl_system_items
2205: WHERE mtl_system_items.inventory_item_id = p_item_id
2206: AND mtl_system_items.organization_id = p_organization_id;
2207: EXCEPTION
2208: WHEN NO_DATA_FOUND THEN
2209: --Bug5574012:In case of one time items,the UOM will be fetched from the
2210: --PO data.Setting the g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure

Line 2789: , mtl_system_items msi

2785: FROM rcv_transactions rt
2786: , rcv_supply rsup
2787: , rcv_shipment_headers rsh
2788: , rcv_shipment_lines rsl
2789: , mtl_system_items msi
2790: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
2791: AND rsup.shipment_line_id = v_shipment_line_id
2792: AND rsup.to_organization_id = p_organization_id
2793: AND rsl.shipment_line_id = rsup.shipment_line_id

Line 2909: FROM mtl_system_items

2905:
2906: BEGIN
2907: SELECT primary_unit_of_measure
2908: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2909: FROM mtl_system_items
2910: WHERE mtl_system_items.inventory_item_id = p_item_id
2911: AND mtl_system_items.organization_id = p_organization_id;
2912: EXCEPTION
2913: WHEN NO_DATA_FOUND THEN

Line 2910: WHERE mtl_system_items.inventory_item_id = p_item_id

2906: BEGIN
2907: SELECT primary_unit_of_measure
2908: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2909: FROM mtl_system_items
2910: WHERE mtl_system_items.inventory_item_id = p_item_id
2911: AND mtl_system_items.organization_id = p_organization_id;
2912: EXCEPTION
2913: WHEN NO_DATA_FOUND THEN
2914: NULL;

Line 2911: AND mtl_system_items.organization_id = p_organization_id;

2907: SELECT primary_unit_of_measure
2908: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2909: FROM mtl_system_items
2910: WHERE mtl_system_items.inventory_item_id = p_item_id
2911: AND mtl_system_items.organization_id = p_organization_id;
2912: EXCEPTION
2913: WHEN NO_DATA_FOUND THEN
2914: NULL;
2915: END;

Line 3458: , mtl_system_items msi

3454: FROM rcv_transactions rt
3455: , rcv_supply rsup
3456: , rcv_shipment_headers rsh
3457: , rcv_shipment_lines rsl
3458: , mtl_system_items msi
3459: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
3460: AND rsup.oe_order_line_id = v_order_line_id
3461: AND rsup.to_organization_id = p_organization_id
3462: AND rsl.shipment_line_id = rsup.shipment_line_id

Line 3541: FROM mtl_system_items

3537:
3538: BEGIN
3539: SELECT primary_unit_of_measure
3540: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
3541: FROM mtl_system_items
3542: WHERE mtl_system_items.inventory_item_id = p_item_id
3543: AND mtl_system_items.organization_id = p_organization_id;
3544: EXCEPTION
3545: WHEN NO_DATA_FOUND THEN

Line 3542: WHERE mtl_system_items.inventory_item_id = p_item_id

3538: BEGIN
3539: SELECT primary_unit_of_measure
3540: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
3541: FROM mtl_system_items
3542: WHERE mtl_system_items.inventory_item_id = p_item_id
3543: AND mtl_system_items.organization_id = p_organization_id;
3544: EXCEPTION
3545: WHEN NO_DATA_FOUND THEN
3546: NULL;

Line 3543: AND mtl_system_items.organization_id = p_organization_id;

3539: SELECT primary_unit_of_measure
3540: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
3541: FROM mtl_system_items
3542: WHERE mtl_system_items.inventory_item_id = p_item_id
3543: AND mtl_system_items.organization_id = p_organization_id;
3544: EXCEPTION
3545: WHEN NO_DATA_FOUND THEN
3546: NULL;
3547: END;