APPS.INV_TXN_MANAGER_GRP dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 934: FROM ORG_ORGANIZATION_DEFINITIONS

930: END IF;
931:
932: SELECT CHART_OF_ACCOUNTS_ID
933: INTO l_chart
934: FROM ORG_ORGANIZATION_DEFINITIONS
935: WHERE ORGANIZATION_ID = p_orgid;
936:
937:
938: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');

Line 1185: FROM ORG_ORGANIZATION_DEFINITIONS

1181: WHERE ROWID = p_rowid;
1182:
1183: SELECT CHART_OF_ACCOUNTS_ID
1184: INTO l_chart
1185: FROM ORG_ORGANIZATION_DEFINITIONS
1186: WHERE ORGANIZATION_ID = p_orgid;
1187:
1188:
1189: -- find flex field type

Line 2821: ORG_ORGANIZATION_DEFINITIONS OOD

2817: AND TRANSACTION_SOURCE_TYPE_ID = 3
2818: AND NOT EXISTS (
2819: SELECT NULL
2820: FROM GL_CODE_COMBINATIONS GCC,
2821: ORG_ORGANIZATION_DEFINITIONS OOD
2822: WHERE GCC.CODE_COMBINATION_ID = MTI.TRANSACTION_SOURCE_ID
2823: AND GCC.CHART_OF_ACCOUNTS_ID = OOD.CHART_OF_ACCOUNTS_ID
2824: AND OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2825: AND GCC.ENABLED_FLAG = 'Y'

Line 2940: FROM ORG_ORGANIZATION_DEFINITIONS OOD

2936: WHERE TRANSACTION_HEADER_ID = p_header_id
2937: AND PROCESS_FLAG = 1
2938: AND NOT EXISTS (
2939: SELECT NULL
2940: FROM ORG_ORGANIZATION_DEFINITIONS OOD
2941: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2942: AND NVL(OOD.DISABLE_DATE, SYSDATE + 1) > SYSDATE);
2943:
2944: l_count := SQL%ROWCOUNT;

Line 2973: FROM ORG_ORGANIZATION_DEFINITIONS OOD

2969: AND TRANSACTION_ACTION_ID in (3,21)
2970: AND PROCESS_FLAG = 1
2971: AND (NOT EXISTS (
2972: SELECT NULL
2973: FROM ORG_ORGANIZATION_DEFINITIONS OOD
2974: WHERE OOD.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
2975: AND NVL(OOD.DISABLE_DATE, SYSDATE + 1) > SYSDATE)
2976: OR NOT EXISTS (
2977: SELECT NULL

Line 3417: FROM ORG_ORGANIZATION_DEFINITIONS OOD

3413: FROM GL_CODE_COMBINATIONS GCC
3414: WHERE GCC.CODE_COMBINATION_ID = MTI.DISTRIBUTION_ACCOUNT_ID
3415: AND GCC.CHART_OF_ACCOUNTS_ID
3416: = (SELECT CHART_OF_ACCOUNTS_ID
3417: FROM ORG_ORGANIZATION_DEFINITIONS OOD
3418: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
3419: AND GCC.ENABLED_FLAG = 'Y'
3420: AND NVL(GCC.START_DATE_ACTIVE, MTI.TRANSACTION_DATE - 1) <= MTI.TRANSACTION_DATE
3421: AND NVL(GCC.END_DATE_ACTIVE, MTI.TRANSACTION_DATE + 1) > MTI.TRANSACTION_DATE);

Line 7699: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7695: FROM GL_CODE_COMBINATIONS GCC
7696: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_ACCOUNT
7697: AND GCC.CHART_OF_ACCOUNTS_ID
7698: = (SELECT CHART_OF_ACCOUNTS_ID
7699: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7700: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7701: AND GCC.ENABLED_FLAG = 'Y'
7702: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7703: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));

Line 7747: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7743: FROM GL_CODE_COMBINATIONS GCC
7744: WHERE GCC.CODE_COMBINATION_ID = MTI.MATERIAL_OVERHEAD_ACCOUNT
7745: AND GCC.CHART_OF_ACCOUNTS_ID
7746: = (SELECT CHART_OF_ACCOUNTS_ID
7747: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7748: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7749: AND GCC.ENABLED_FLAG = 'Y'
7750: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7751: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));

Line 7794: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7790: FROM GL_CODE_COMBINATIONS GCC
7791: WHERE GCC.CODE_COMBINATION_ID = MTI.RESOURCE_ACCOUNT
7792: AND GCC.CHART_OF_ACCOUNTS_ID
7793: = (SELECT CHART_OF_ACCOUNTS_ID
7794: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7795: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7796: AND GCC.ENABLED_FLAG = 'Y'
7797: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7798: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));

Line 7841: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7837: FROM GL_CODE_COMBINATIONS GCC
7838: WHERE GCC.CODE_COMBINATION_ID = MTI.OUTSIDE_PROCESSING_ACCOUNT
7839: AND GCC.CHART_OF_ACCOUNTS_ID
7840: = (SELECT CHART_OF_ACCOUNTS_ID
7841: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7842: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7843: AND GCC.ENABLED_FLAG = 'Y'
7844: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7845: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));

Line 7888: FROM ORG_ORGANIZATION_DEFINITIONS OOD

7884: FROM GL_CODE_COMBINATIONS GCC
7885: WHERE GCC.CODE_COMBINATION_ID = MTI.OVERHEAD_ACCOUNT
7886: AND GCC.CHART_OF_ACCOUNTS_ID
7887: = (SELECT CHART_OF_ACCOUNTS_ID
7888: FROM ORG_ORGANIZATION_DEFINITIONS OOD
7889: WHERE OOD.ORGANIZATION_ID = MTI.ORGANIZATION_ID)
7890: AND GCC.ENABLED_FLAG = 'Y'
7891: AND trunc(NVL(GCC.START_DATE_ACTIVE, mti.transaction_date - 1)) <= trunc(mti.transaction_date)
7892: AND trunc(NVL(GCC.END_DATE_ACTIVE, mti.transaction_date + 1)) >= trunc(mti.transaction_date));