DBA Data[Home] [Help]

APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 303: from mtl_transactions_interface

299: and inventory_item_id = p_item_id
300: and open_flag = 'Y'
301: and ship_from_org_id = p_org_id
302: and exists (select 1
303: from mtl_transactions_interface
304: where trx_source_line_id = l.line_id
305: and transaction_source_type_id in (2,8)
306: and source_code = 'ORDER ENTRY')
307: and rownum = 1;

Line 411: from mtl_transactions_interface

407: from mtl_parameters
408: where master_organization_id = l_master_org)
409: -- bug 9558897, base bug 9327156, perf issue
410: and exists (select 1
411: from mtl_transactions_interface
412: where trx_source_line_id = l.line_id
413: and transaction_source_type_id in (2,8)
414: and source_code = 'ORDER ENTRY')
415: and rownum = 1;