DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1064: from mtl_system_items_fvl a

1060: and
1061: ( item_type = 3 -- All items
1062: OR
1063: item_type = (select planning_make_buy_code
1064: from mtl_system_items_fvl a
1065: where organization_id = cp_organization_id
1066: and inventory_item_id = cp_item_id
1067: )
1068: )

Line 1320: from mtl_system_items

1316: where line_location_id = cp_po_line_location_id;
1317:
1318: cursor c_fetch_list_price(cp_organization_id number, cp_item_id number) IS
1319: select list_price_per_unit
1320: from mtl_system_items
1321: where inventory_item_id = cp_item_id
1322: and organization_id = cp_organization_id;
1323:
1324: cursor c_fetch_unit_price(cp_requisition_line_id number) IS