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)
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)
214: x_progress := '010';
215:
216: SELECT count(1)
217: INTO x_sub_count
218: FROM mtl_secondary_inventories msub,
219: mtl_system_items msi
220: WHERE msub.organization_id = x_source_org_id
221: AND msub.secondary_inventory_name = x_subinventory
222: AND msi.inventory_item_id = x_item_id