DBA Data[Home] [Help]

APPS.FLM_PURGE dependencies on MTL_TRANSACTION_ACCOUNTS

Line 44: FROM MTL_TRANSACTION_ACCOUNTS MTA , MTL_MATERIAL_TRANSACTIONS MMT

40: into l_records_found
41: FROM DUAL
42: WHERE EXISTS
43: (SELECT 1
44: FROM MTL_TRANSACTION_ACCOUNTS MTA , MTL_MATERIAL_TRANSACTIONS MMT
45: WHERE MMT.ORGANIZATION_ID = arg_org_id
46: AND MMT.TRANSACTION_SOURCE_ID = arg_wip_entity_id
47: AND MMT.TRANSACTION_ID = MTA.TRANSACTION_ID
48: AND MMT.TRANSACTION_SOURCE_TYPE_ID +0 = 5 );