DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_GENERIC_DISPOSITIONS

Line 1414: FROM MTL_GENERIC_DISPOSITIONS

1410: IF (l_srctype = 3 OR l_srctype = 6) THEN
1411: IF (l_srctype = 6) THEN
1412: SELECT DISTRIBUTION_ACCOUNT
1413: INTO l_acctid
1414: FROM MTL_GENERIC_DISPOSITIONS
1415: WHERE ORGANIZATION_ID = c_mti_row.organization_id
1416: AND DISPOSITION_ID = l_trxsrc;
1417: ELSE
1418: l_acctid := l_trxsrc;

Line 2850: FROM MTL_GENERIC_DISPOSITIONS MGD

2846: AND PROCESS_FLAG = 1
2847: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_AccountAlias
2848: AND NOT EXISTS (
2849: SELECT NULL
2850: FROM MTL_GENERIC_DISPOSITIONS MGD
2851: WHERE MGD.DISPOSITION_ID = MTI.TRANSACTION_SOURCE_ID
2852: AND MGD.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2853: AND MGD.ENABLED_FLAG = 'Y'
2854: AND NVL(MGD.EFFECTIVE_DATE, SYSDATE - 1) <= SYSDATE

Line 8347: FROM MTL_GENERIC_DISPOSITIONS

8343: IF (l_srctype = 3 OR l_srctype = 6) THEN
8344: IF (l_srctype = 6) THEN
8345: SELECT DISTRIBUTION_ACCOUNT
8346: INTO l_acct
8347: FROM MTL_GENERIC_DISPOSITIONS
8348: WHERE ORGANIZATION_ID = l_orgid
8349: AND DISPOSITION_ID = l_trxsrc;
8350: ELSE
8351: l_acct := l_trxsrc;