[Home] [Help]
87: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
88: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
89: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
90: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
91: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';
92: ELSE
93: P_PERIOD_INX_HINT := ' /*+ ORDERED
94: USE_NL(CC) INDEX (CC GL_CODE_COMBINATIONS_N2
95: INDEX (CC GL_CODE_COMBINATIONS_N3)
108: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
109: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
110: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
111: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
112: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
113: END IF;
114: ELSIF ((P_STATUS = 'E') OR (P_STATUS = 'U')) THEN
115: P_PERIOD_INX_HINT := '/*+ ORDERED */';
116: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
116: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
117: GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
118: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,
119: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
120: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
121: END IF;
122: ELSE
123: F_PERIOD_NUM := GET_EFF_PERIOD_NUM(P_ACCESS_SET_ID
124: ,P_PERIOD_FROM);
144: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
145: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
146: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
147: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
148: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ';
149: ELSE
150: P_PERIOD_INX_HINT := ' /*+ ORDERED
151: USE_NL(CC) INDEX (CC GL_CODE_COMBINATIONS_N2
152: INDEX (CC GL_CODE_COMBINATIONS_N3)
165: P_FROM_CLAUSE := 'GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
166: GL_JE_LINES GLL, GL_JE_HEADERS GLH, GL_LEDGERS LGR,
167: GL_LEDGER_CONFIGURATIONS glc, GL_JE_BATCHES GLBATCH,
168: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
169: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT, GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
170: END IF;
171: ELSIF ((P_STATUS = 'E') OR (P_STATUS = 'U')) THEN
172: P_PERIOD_INX_HINT := '/*+ ORDERED */';
173: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
173: P_FROM_CLAUSE := ' GL_JE_BATCHES GLBATCH, GL_JE_HEADERS GLH, GL_JE_LINES GLL,
174: GL_CODE_COMBINATIONS CC, GL_PERIOD_STATUSES GLP,
175: GL_LEDGERS LGR, GL_LEDGER_CONFIGURATIONS glc,
176: FUN_SEQ_VERSIONS FSV, FND_DOCUMENT_SEQUENCES DOCSEQ,
177: GL_JE_SOURCES SRC, GL_JE_CATEGORIES CAT , GL_LOOKUPS LOOK ' || P_LEDGER_FROM;
178: END IF;
179: END IF;
180: IF ((P_START_DATE IS NOT NULL) OR (P_END_DATE IS NOT NULL)) THEN
181: IF (P_START_DATE = P_END_DATE) THEN
200: IF (DAS_WHERE IS NOT NULL) THEN
201: DAS_WHERE := ' AND ' || DAS_WHERE;
202: END IF;
203: IF (P_STATUS = 'E') THEN
204: P_POSTING_STATUS := ' AND ' || ' GLBATCH.STATUS IN ' || '(SELECT LOOKUP_CODE FROM GL_LOOKUPS ' || 'WHERE LOOKUP_TYPE = ''MJE_BATCH_STATUS'' ' || 'AND LOOKUP_CODE NOT IN (''S'', ''I'', ''U'', ''P'')) ';
205: P_HEADER_POSTING_STATUS := ' AND GLH.JE_HEADER_ID = GLL.JE_HEADER_ID(+)
206: AND GLL.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID(+) ';
207: ELSE
208: P_POSTING_STATUS := 'AND GLBATCH.STATUS = ''' || P_STATUS || '''';
282: SELECT
283: MEANING
284: INTO POSTING_STATUS_PARAM
285: FROM
286: GL_LOOKUPS
287: WHERE LOOKUP_CODE = P_STATUS
288: AND LOOKUP_TYPE = 'JOURNAL_REPORT_TYPE';
289: IF P_BALANCE_TYPE IS NOT NULL THEN
290: SELECT
290: SELECT
291: DESCRIPTION
292: INTO BALANCE_TYPE_PARAM
293: FROM
294: GL_LOOKUPS
295: WHERE LOOKUP_TYPE = 'BATCH_TYPE'
296: AND LOOKUP_CODE = P_BALANCE_TYPE;
297: END IF;
298: IF P_SOURCE IS NOT NULL THEN