APPS.INV_TXN_MANAGER_GRP dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 813: FROM ORG_ORGANIZATION_DEFINITIONS

809: catsegs varchar2(200);
810: BEGIN
811: SELECT CHART_OF_ACCOUNTS_ID
812: INTO l_chart
813: FROM ORG_ORGANIZATION_DEFINITIONS
814: WHERE ORGANIZATION_ID = p_orgid;
815:
816: IF fnd_flex_keyval.validate_ccid ( APPL_SHORT_NAME => 'SQLGL'
817: ,KEY_FLEX_CODE => 'GL#'

Line 924: FROM ORG_ORGANIZATION_DEFINITIONS

920: END IF;
921:
922: SELECT CHART_OF_ACCOUNTS_ID
923: INTO l_chart
924: FROM ORG_ORGANIZATION_DEFINITIONS
925: WHERE ORGANIZATION_ID = p_orgid;
926:
927:
928: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');

Line 1175: FROM ORG_ORGANIZATION_DEFINITIONS

1171: WHERE ROWID = p_rowid;
1172:
1173: SELECT CHART_OF_ACCOUNTS_ID
1174: INTO l_chart
1175: FROM ORG_ORGANIZATION_DEFINITIONS
1176: WHERE ORGANIZATION_ID = p_orgid;
1177:
1178:
1179: -- find flex field type

Line 2674: ORG_ORGANIZATION_DEFINITIONS OOD

2670: AND TRANSACTION_SOURCE_TYPE_ID = 3
2671: AND NOT EXISTS (
2672: SELECT NULL
2673: FROM GL_CODE_COMBINATIONS GCC,
2674: ORG_ORGANIZATION_DEFINITIONS OOD
2675: WHERE GCC.CODE_COMBINATION_ID = MTI.TRANSACTION_SOURCE_ID
2676: AND GCC.CHART_OF_ACCOUNTS_ID = OOD.CHART_OF_ACCOUNTS_ID
2677: AND OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2678: AND GCC.ENABLED_FLAG = 'Y'

Line 2793: FROM ORG_ORGANIZATION_DEFINITIONS OOD

2789: WHERE TRANSACTION_HEADER_ID = p_header_id
2790: AND PROCESS_FLAG = 1
2791: AND NOT EXISTS (
2792: SELECT NULL
2793: FROM ORG_ORGANIZATION_DEFINITIONS OOD
2794: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2795: AND NVL(OOD.DISABLE_DATE, SYSDATE + 1) > SYSDATE);
2796:
2797: l_count := SQL%ROWCOUNT;

Line 2826: FROM ORG_ORGANIZATION_DEFINITIONS OOD

2822: AND TRANSACTION_ACTION_ID in (3,21)
2823: AND PROCESS_FLAG = 1
2824: AND (NOT EXISTS (
2825: SELECT NULL
2826: FROM ORG_ORGANIZATION_DEFINITIONS OOD
2827: WHERE OOD.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
2828: AND NVL(OOD.DISABLE_DATE, SYSDATE + 1) > SYSDATE)
2829: OR NOT EXISTS (
2830: SELECT NULL

Line 3230: FROM ORG_ORGANIZATION_DEFINITIONS OOD

3226: FROM GL_CODE_COMBINATIONS GCC
3227: WHERE GCC.CODE_COMBINATION_ID = MTI.DISTRIBUTION_ACCOUNT_ID
3228: AND GCC.CHART_OF_ACCOUNTS_ID
3229: = (SELECT CHART_OF_ACCOUNTS_ID
3230: FROM ORG_ORGANIZATION_DEFINITIONS OOD
3231: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
3232: AND GCC.ENABLED_FLAG = 'Y'
3233: AND NVL(GCC.START_DATE_ACTIVE, MTI.TRANSACTION_DATE - 1) <= MTI.TRANSACTION_DATE
3234: AND NVL(GCC.END_DATE_ACTIVE, MTI.TRANSACTION_DATE + 1) > MTI.TRANSACTION_DATE);

Line 7184: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7180: FROM GL_CODE_COMBINATIONS GCC
7181: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_ACCOUNT
7182: AND GCC.CHART_OF_ACCOUNTS_ID
7183: = (SELECT CHART_OF_ACCOUNTS_ID
7184: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7185: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7186: AND GCC.ENABLED_FLAG = 'Y'
7187: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7188: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));

Line 7232: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7228: FROM GL_CODE_COMBINATIONS GCC
7229: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_OVERHEAD_ACCOUNT
7230: AND GCC.CHART_OF_ACCOUNTS_ID
7231: = (SELECT CHART_OF_ACCOUNTS_ID
7232: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7233: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7234: AND GCC.ENABLED_FLAG = 'Y'
7235: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7236: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));

Line 7279: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7275: FROM GL_CODE_COMBINATIONS GCC
7276: WHERE GCC.CODE_COMBINATION_ID = MTI.RESOURCE_ACCOUNT
7277: AND GCC.CHART_OF_ACCOUNTS_ID
7278: = (SELECT CHART_OF_ACCOUNTS_ID
7279: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7280: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7281: AND GCC.ENABLED_FLAG = 'Y'
7282: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7283: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));

Line 7326: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7322: FROM GL_CODE_COMBINATIONS GCC
7323: WHERE GCC.CODE_COMBINATION_ID = MTI.OUTSIDE_PROCESSING_ACCOUNT
7324: AND GCC.CHART_OF_ACCOUNTS_ID
7325: = (SELECT CHART_OF_ACCOUNTS_ID
7326: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7327: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7328: AND GCC.ENABLED_FLAG = 'Y'
7329: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7330: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));

Line 7373: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7369: FROM GL_CODE_COMBINATIONS GCC
7370: WHERE GCC.CODE_COMBINATION_ID = MTI.OVERHEAD_ACCOUNT
7371: AND GCC.CHART_OF_ACCOUNTS_ID
7372: = (SELECT CHART_OF_ACCOUNTS_ID
7373: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7374: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7375: AND GCC.ENABLED_FLAG = 'Y'
7376: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7377: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));

Line 7437: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7433: FROM GL_CODE_COMBINATIONS GCC
7434: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_EXPENSE_ACCOUNT
7435: AND GCC.CHART_OF_ACCOUNTS_ID =
7436: (SELECT CHART_OF_ACCOUNTS_ID
7437: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7438: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7439: AND GCC.ENABLED_FLAG = 'Y'
7440: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7441: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));