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 1657: , mtl_system_items msi

1653: FROM rcv_transactions rt
1654: , rcv_supply rsup
1655: , rcv_shipment_headers rsh
1656: , rcv_shipment_lines rsl
1657: , mtl_system_items msi
1658: , po_lines pol
1659: , po_distributions pod
1660: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
1661: AND rsup.to_organization_id = p_organization_id

Line 1727: FROM mtl_system_items

1723:
1724: BEGIN
1725: SELECT primary_unit_of_measure
1726: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
1727: FROM mtl_system_items
1728: WHERE mtl_system_items.inventory_item_id = p_item_id
1729: AND mtl_system_items.organization_id = p_organization_id;
1730: EXCEPTION
1731: WHEN NO_DATA_FOUND THEN

Line 1728: WHERE mtl_system_items.inventory_item_id = p_item_id

1724: BEGIN
1725: SELECT primary_unit_of_measure
1726: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
1727: FROM mtl_system_items
1728: WHERE mtl_system_items.inventory_item_id = p_item_id
1729: AND mtl_system_items.organization_id = p_organization_id;
1730: EXCEPTION
1731: WHEN NO_DATA_FOUND THEN
1732: NULL;

Line 1729: AND mtl_system_items.organization_id = p_organization_id;

1725: SELECT primary_unit_of_measure
1726: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
1727: FROM mtl_system_items
1728: WHERE mtl_system_items.inventory_item_id = p_item_id
1729: AND mtl_system_items.organization_id = p_organization_id;
1730: EXCEPTION
1731: WHEN NO_DATA_FOUND THEN
1732: NULL;
1733: END;

Line 2038: , mtl_system_items msi

2034: FROM rcv_transactions rt
2035: , rcv_supply rsup
2036: , rcv_shipment_headers rsh
2037: , rcv_shipment_lines rsl
2038: , mtl_system_items msi
2039: , po_lines pol
2040: , po_distributions pod
2041: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
2042: AND rsup.to_organization_id = p_organization_id

Line 2238: FROM mtl_system_items

2234:
2235: BEGIN
2236: SELECT primary_unit_of_measure
2237: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2238: FROM mtl_system_items
2239: WHERE mtl_system_items.inventory_item_id = p_item_id
2240: AND mtl_system_items.organization_id = p_organization_id;
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN

Line 2239: WHERE mtl_system_items.inventory_item_id = p_item_id

2235: BEGIN
2236: SELECT primary_unit_of_measure
2237: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2238: FROM mtl_system_items
2239: WHERE mtl_system_items.inventory_item_id = p_item_id
2240: AND mtl_system_items.organization_id = p_organization_id;
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN
2243: --Bug5574012:In case of one time items,the UOM will be fetched from the

Line 2240: AND mtl_system_items.organization_id = p_organization_id;

2236: SELECT primary_unit_of_measure
2237: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2238: FROM mtl_system_items
2239: WHERE mtl_system_items.inventory_item_id = p_item_id
2240: AND mtl_system_items.organization_id = p_organization_id;
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN
2243: --Bug5574012:In case of one time items,the UOM will be fetched from the
2244: --PO data.Setting the g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure

Line 2823: , mtl_system_items msi

2819: FROM rcv_transactions rt
2820: , rcv_supply rsup
2821: , rcv_shipment_headers rsh
2822: , rcv_shipment_lines rsl
2823: , mtl_system_items msi
2824: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
2825: AND rsup.shipment_line_id = v_shipment_line_id
2826: AND rsup.to_organization_id = p_organization_id
2827: AND rsl.shipment_line_id = rsup.shipment_line_id

Line 2970: FROM mtl_system_items

2966:
2967: BEGIN
2968: SELECT primary_unit_of_measure
2969: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2970: FROM mtl_system_items
2971: WHERE mtl_system_items.inventory_item_id = p_item_id
2972: AND mtl_system_items.organization_id = p_organization_id;
2973: EXCEPTION
2974: WHEN NO_DATA_FOUND THEN

Line 2971: WHERE mtl_system_items.inventory_item_id = p_item_id

2967: BEGIN
2968: SELECT primary_unit_of_measure
2969: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2970: FROM mtl_system_items
2971: WHERE mtl_system_items.inventory_item_id = p_item_id
2972: AND mtl_system_items.organization_id = p_organization_id;
2973: EXCEPTION
2974: WHEN NO_DATA_FOUND THEN
2975: NULL;

Line 2972: AND mtl_system_items.organization_id = p_organization_id;

2968: SELECT primary_unit_of_measure
2969: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
2970: FROM mtl_system_items
2971: WHERE mtl_system_items.inventory_item_id = p_item_id
2972: AND mtl_system_items.organization_id = p_organization_id;
2973: EXCEPTION
2974: WHEN NO_DATA_FOUND THEN
2975: NULL;
2976: END;

Line 3554: , mtl_system_items msi

3550: FROM rcv_transactions rt
3551: , rcv_supply rsup
3552: , rcv_shipment_headers rsh
3553: , rcv_shipment_lines rsl
3554: , mtl_system_items msi
3555: WHERE rsup.rcv_transaction_id = v_rcv_txn_id
3556: AND rsup.oe_order_line_id = v_order_line_id
3557: AND rsup.to_organization_id = p_organization_id
3558: AND rsl.shipment_line_id = rsup.shipment_line_id

Line 3637: FROM mtl_system_items

3633:
3634: BEGIN
3635: SELECT primary_unit_of_measure
3636: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
3637: FROM mtl_system_items
3638: WHERE mtl_system_items.inventory_item_id = p_item_id
3639: AND mtl_system_items.organization_id = p_organization_id;
3640: EXCEPTION
3641: WHEN NO_DATA_FOUND THEN

Line 3638: WHERE mtl_system_items.inventory_item_id = p_item_id

3634: BEGIN
3635: SELECT primary_unit_of_measure
3636: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
3637: FROM mtl_system_items
3638: WHERE mtl_system_items.inventory_item_id = p_item_id
3639: AND mtl_system_items.organization_id = p_organization_id;
3640: EXCEPTION
3641: WHEN NO_DATA_FOUND THEN
3642: NULL;

Line 3639: AND mtl_system_items.organization_id = p_organization_id;

3635: SELECT primary_unit_of_measure
3636: INTO g_rcvtxn_match_table_gross(g_rcvtxn_detail_index).primary_unit_of_measure
3637: FROM mtl_system_items
3638: WHERE mtl_system_items.inventory_item_id = p_item_id
3639: AND mtl_system_items.organization_id = p_organization_id;
3640: EXCEPTION
3641: WHEN NO_DATA_FOUND THEN
3642: NULL;
3643: END;