DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_GENERIC_DISPOSITIONS

Line 1404: FROM MTL_GENERIC_DISPOSITIONS

1400: IF (l_srctype = 3 OR l_srctype = 6) THEN
1401: IF (l_srctype = 6) THEN
1402: SELECT DISTRIBUTION_ACCOUNT
1403: INTO l_acctid
1404: FROM MTL_GENERIC_DISPOSITIONS
1405: WHERE ORGANIZATION_ID = c_mti_row.organization_id
1406: AND DISPOSITION_ID = l_trxsrc;
1407: ELSE
1408: l_acctid := l_trxsrc;

Line 2703: FROM MTL_GENERIC_DISPOSITIONS MGD

2699: AND PROCESS_FLAG = 1
2700: AND TRANSACTION_SOURCE_TYPE_ID = INV_GLOBALS.G_SourceType_AccountAlias
2701: AND NOT EXISTS (
2702: SELECT NULL
2703: FROM MTL_GENERIC_DISPOSITIONS MGD
2704: WHERE MGD.DISPOSITION_ID = MTI.TRANSACTION_SOURCE_ID
2705: AND MGD.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2706: AND MGD.ENABLED_FLAG = 'Y'
2707: AND NVL(MGD.EFFECTIVE_DATE, SYSDATE - 1) <= SYSDATE

Line 7850: FROM MTL_GENERIC_DISPOSITIONS

7846: IF (l_srctype = 3 OR l_srctype = 6) THEN
7847: IF (l_srctype = 6) THEN
7848: SELECT DISTRIBUTION_ACCOUNT
7849: INTO l_acct
7850: FROM MTL_GENERIC_DISPOSITIONS
7851: WHERE ORGANIZATION_ID = l_orgid
7852: AND DISPOSITION_ID = l_trxsrc;
7853: ELSE
7854: l_acct := l_trxsrc;