DBA Data[Home] [Help]

APPS.GMF_RCV_ACCOUNTING_PKG dependencies on MTL_SYSTEM_ITEMS

Line 869: FROM mtl_system_items msi

865: l_stmt_num := 30;
866:
867: SELECT COUNT (*)
868: INTO l_item_exists
869: FROM mtl_system_items msi
870: WHERE msi.inventory_item_id = p_rcv_accttxn.item_id
871: AND msi.organization_id = p_rcv_accttxn.organization_id;
872:
873: IF (l_item_exists = 0)

Line 898: FROM mtl_system_items msi, po_line_locations poll

894: l_stmt_num := 40;
895:
896: SELECT msi.inventory_asset_flag
897: INTO l_asset_flag
898: FROM mtl_system_items msi, po_line_locations poll
899: WHERE msi.inventory_item_id = p_rcv_accttxn.item_id
900: AND msi.organization_id = poll.ship_to_organization_id
901: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id;
902: EXCEPTION

Line 1590: FROM mtl_system_items

1586: l_stmt_num := 30;
1587:
1588: SELECT primary_uom_code
1589: INTO l_primary_uom_code
1590: FROM mtl_system_items
1591: WHERE organization_id = p_event_rec.organization_id
1592: AND inventory_item_id = l_item_id;
1593:
1594: l_stmt_num := 40;