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 219: mtl_system_items msi

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