DBA Data[Home] [Help]

APPS.PO_SUBINVENTORIES_S dependencies on MTL_ITEM_SUB_INVENTORIES

Line 103: FROM MTL_ITEM_SUB_INVENTORIES

99: BEGIN
100:
101: SELECT 'sub_ok'
102: INTO x_status
103: FROM MTL_ITEM_SUB_INVENTORIES
104: WHERE INVENTORY_ITEM_ID = x_item_id
105: AND SECONDARY_INVENTORY = x_subinventory
106: AND ORGANIZATION_ID = x_organization_id;
107:

Line 743: FROM mtl_item_sub_inventories mis

739: x_progress := '030';
740:
741: SELECT count(1)
742: INTO x_count
743: FROM mtl_item_sub_inventories mis
744: WHERE mis.inventory_item_id = x_item_id
745: AND mis.secondary_inventory = x_src_sub
746: AND mis.organization_id = x_src_org_id;
747: