DBA Data[Home] [Help]

APPS.INV_MO_LOVS dependencies on MTL_SYSTEM_ITEMS

Line 44: FROM mtl_system_items msi

40: AND NVL(l.quantity_delivered, 0) < l.quantity
41: AND l.header_id = h.header_id
42: AND EXISTS(
43: SELECT NULL
44: FROM mtl_system_items msi
45: WHERE msi.inventory_item_id = l.inventory_item_id
46: AND msi.organization_id = l.organization_id
47: AND msi.mtl_transactions_enabled_flag = 'Y'
48: AND msi.inventory_item_flag = 'Y'

Line 173: FROM mtl_system_items msi

169: AND NVL(l.quantity_delivered, 0) < l.quantity
170: AND l.header_id = h.header_id
171: AND EXISTS(
172: SELECT NULL
173: FROM mtl_system_items msi
174: WHERE msi.inventory_item_id = l.inventory_item_id
175: AND msi.organization_id = l.organization_id
176: AND msi.mtl_transactions_enabled_flag = 'Y'
177: AND msi.inventory_item_flag = 'Y'

Line 202: FROM mtl_system_items msi

198: AND NVL(l.quantity_delivered, 0) < l.quantity
199: AND l.header_id = h.header_id
200: AND EXISTS(
201: SELECT NULL
202: FROM mtl_system_items msi
203: WHERE msi.inventory_item_id = l.inventory_item_id
204: AND msi.organization_id = l.organization_id
205: AND msi.mtl_transactions_enabled_flag = 'Y'
206: AND msi.inventory_item_flag = 'Y'

Line 239: FROM mtl_system_items msi

235: AND NVL(l.quantity_delivered, 0) < l.quantity
236: AND l.header_id = h.header_id
237: AND EXISTS(
238: SELECT NULL
239: FROM mtl_system_items msi
240: WHERE msi.inventory_item_id = l.inventory_item_id
241: AND msi.organization_id = l.organization_id
242: AND msi.mtl_transactions_enabled_flag = 'Y'
243: AND msi.inventory_item_flag = 'Y'

Line 280: FROM mtl_system_items msi

276: AND header_id = p_mo_header_id
277: AND line_number LIKE(p_line_number)
278: AND EXISTS(
279: SELECT NULL
280: FROM mtl_system_items msi
281: WHERE msi.inventory_item_id = mtrl.inventory_item_id
282: AND msi.organization_id = p_organization_id
283: AND msi.mtl_transactions_enabled_flag = 'Y'
284: AND msi.inventory_item_flag = 'Y'