DBA Data[Home] [Help]

APPS.INV_RCV_STD_TRANSFER_APIS dependencies on MTL_SYSTEM_ITEMS

Line 1198: , mtl_system_items msi

1194: , rcv_supply rs
1195: , rcv_shipment_headers rsh
1196: , rcv_shipment_lines rsl
1197: , po_lines pol
1198: , mtl_system_items msi
1199: WHERE rs.rcv_transaction_id = v_rcv_txn_id
1200: AND rs.to_organization_id = p_organization_id
1201: AND rs.rcv_transaction_id = rt.transaction_id
1202: AND rs.po_line_location_id = v_po_line_location_id

Line 1277: FROM mtl_system_items

1273: INTO l_primary_uom
1274: , l_primary_uom_code
1275: -- , l_secondary_uom ----OPM Convergence
1276: , l_secondary_uom_code --OPM Convergence
1277: FROM mtl_system_items
1278: WHERE inventory_item_id = p_item_id
1279: AND organization_id = p_organization_id;
1280:
1281: SELECT unit_of_measure

Line 1632: , mtl_system_items msi

1628: FROM rcv_transactions rt
1629: , rcv_supply rs
1630: , rcv_shipment_headers rsh
1631: , rcv_shipment_lines rsl
1632: , mtl_system_items msi
1633: WHERE rs.rcv_transaction_id = v_rcv_txn_id
1634: AND rs.to_organization_id = p_organization_id
1635: AND rs.rcv_transaction_id = rt.transaction_id
1636: AND rs.shipment_line_id = v_shipment_line_id

Line 1701: FROM mtl_system_items

1697: INTO l_primary_uom
1698: , l_primary_uom_code
1699: --- , l_secondary_uom
1700: , l_secondary_uom_code
1701: FROM mtl_system_items
1702: WHERE inventory_item_id = p_item_id
1703: AND organization_id = p_organization_id;
1704:
1705: SELECT unit_of_measure

Line 2048: , mtl_system_items msi

2044: FROM rcv_transactions rt
2045: , rcv_supply rs
2046: , rcv_shipment_headers rsh
2047: , rcv_shipment_lines rsl
2048: , mtl_system_items msi
2049: WHERE rs.rcv_transaction_id = v_rcv_txn_id
2050: AND rs.to_organization_id = p_organization_id
2051: AND rs.rcv_transaction_id = rt.transaction_id
2052: AND rs.oe_order_line_id = v_oe_order_line_id

Line 2118: FROM mtl_system_items

2114: INTO l_primary_uom
2115: , l_primary_uom_code
2116: -- , l_secondary_uom
2117: , l_secondary_uom_code
2118: FROM mtl_system_items
2119: WHERE inventory_item_id = p_item_id
2120: AND organization_id = p_organization_id;
2121:
2122: SELECT unit_of_measure

Line 2434: FROM mtl_system_items

2430: END IF;
2431:
2432: SELECT secondary_uom_code
2433: INTO l_sec_uom_code
2434: FROM mtl_system_items
2435: WHERE inventory_item_id = p_item_id
2436: AND organization_id = p_organization_id;
2437:
2438: IF (l_debug = 1) THEN