APPS.PO_SUBINVENTORIES_S2 dependencies on MTL_SECONDARY_INVENTORIES

Line 64: FROM mtl_secondary_inventories msub,

60: x_progress := '010';
61:
62: SELECT count(1)
63: INTO x_sub_count
64: FROM mtl_secondary_inventories msub,
65: mtl_system_items msi
66: WHERE msub.secondary_inventory_name = x_subinventory
67: AND msub.organization_id = x_org_id
68: AND x_transaction_date < nvl(msub.disable_date, x_transaction_date + 1)

Line 139: FROM mtl_secondary_inventories msub

135: x_progress := '040';
136:
137: SELECT count(1)
138: INTO x_sub_count
139: FROM mtl_secondary_inventories msub
140: WHERE msub.secondary_inventory_name = x_source_subinventory
141: AND msub.organization_id = x_source_org_id
142: AND msub.quantity_tracked = 1
143: AND decode(x_reservations, 'Y', 1, msub.reservable_type)

Line 221: FROM mtl_secondary_inventories msub,

217: x_progress := '010';
218:
219: SELECT count(1)
220: INTO x_sub_count
221: FROM mtl_secondary_inventories msub,
222: mtl_system_items msi
223: WHERE msub.organization_id = x_source_org_id
224: AND msub.secondary_inventory_name = x_subinventory
225: AND msi.inventory_item_id = x_item_id