DBA Data[Home] [Help]

APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 266: from mtl_transactions_interface

262: and inventory_item_id = p_item_id
263: and open_flag = 'Y'
264: and ship_from_org_id = p_org_id
265: and exists (select 1
266: from mtl_transactions_interface
267: where trx_source_line_id = l.line_id
268: and transaction_source_type_id in (2,8)
269: and source_code = 'ORDER ENTRY')
270: and rownum = 1;

Line 335: from mtl_transactions_interface

331: and inventory_item_id = p_item_id
332: and open_flag = 'Y'
333: and ship_from_org_id = i.organization_id
334: and exists (select 1
335: from mtl_transactions_interface
336: where trx_source_line_id = l.line_id
337: and transaction_source_type_id in (2,8)
338: and source_code = 'ORDER ENTRY')
339: and rownum = 1;