DBA Data[Home] [Help]

APPS.INV_UPDATE_ONHAND_STATUS dependencies on MTL_SYSTEM_ITEMS

Line 42: select 1 from mtl_system_items msi

38: WHERE moqd.organization_id = org_id
39: AND moqd.status_id is NULL
40: AND rownum < l_bulk_limit
41: AND EXISTS(
42: select 1 from mtl_system_items msi
43: WHERE moqd.inventory_item_id = msi.inventory_item_id
44: AND moqd.organization_id = msi.organization_id
45: AND msi.serial_number_control_code in (1,6)
46: )

Line 166: FROM mtl_onhand_quantities_detail moqd, mtl_system_items_b msi

162:
163: --BEGIN
164: SELECT Count(1)
165: INTO l_count
166: FROM mtl_onhand_quantities_detail moqd, mtl_system_items_b msi
167: WHERE moqd.inventory_item_id = msi.inventory_item_id
168: AND moqd.organization_id = msi.organization_id
169: AND moqd.organization_id = orgid_list(i)
170: AND msi.serial_number_control_code in (1,6)