DBA Data[Home] [Help]

APPS.OPIMPXWI dependencies on WIP_TRANSACTIONS

Line 394: from wip_transactions wt

390: where mmt.organization_id = mp.organization_id
391: and mmt.transaction_date between l_from_date and l_to_date)
392: or exists
393: (select 'there are transactions'
394: from wip_transactions wt
395: where wt.organization_id = mp.organization_id
396: and wt.transaction_date between l_from_date and l_to_date);
397:
398:

Line 412: from wip_transactions

408: from mtl_material_transactions
409: where transaction_date >= l_from_date
410: UNION
411: select distinct organization_id
412: from wip_transactions
413: where transaction_date >= l_from_date
414: UNION
415: select distinct organization_id
416: from mtl_onhand_quantities) mtl