APPS.JAI_RCV_ACCOUNTING_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1007: from mtl_system_items_fvl a

1003: and
1004: ( item_type = 3 -- All items
1005: OR
1006: item_type = (select planning_make_buy_code
1007: from mtl_system_items_fvl a
1008: where organization_id = cp_organization_id
1009: and inventory_item_id = cp_item_id
1010: )
1011: )

Line 1260: from mtl_system_items

1256: where line_location_id = cp_po_line_location_id;
1257:
1258: cursor c_fetch_list_price(cp_organization_id number, cp_item_id number) IS
1259: select list_price_per_unit
1260: from mtl_system_items
1261: where inventory_item_id = cp_item_id
1262: and organization_id = cp_organization_id;
1263:
1264: cursor c_fetch_unit_price(cp_requisition_line_id number) IS