DBA Data[Home] [Help]

APPS.PO_SUBINVENTORIES_S2 dependencies on MTL_SYSTEM_ITEMS

Line 65: mtl_system_items msi

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)
69: AND msi.inventory_item_id = x_item_id

Line 222: mtl_system_items msi

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
226: AND msi.organization_id = x_source_org_id