67262: FROM (
67263: SELECT xet.event_id event_id
67264: , l4.line_number line_number
67265: , CASE r
67266: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67267: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67268: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67269: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67270: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67263: SELECT xet.event_id event_id
67264: , l4.line_number line_number
67265: , CASE r
67266: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67267: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67268: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67269: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67270: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67271: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67264: , l4.line_number line_number
67265: , CASE r
67266: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67267: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67268: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67269: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67270: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67271: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67272: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67265: , CASE r
67266: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67267: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67268: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67269: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67270: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67271: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67272: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67273: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67266: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67267: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67268: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67269: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67270: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67271: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67272: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67273: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67274: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67267: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67268: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67269: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67270: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67271: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67272: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67273: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67274: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67275: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67268: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67269: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67270: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67271: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67272: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67273: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67274: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67275: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67276: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67269: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67270: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67271: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67272: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67273: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67274: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67275: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67276: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67277: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67270: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67271: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67272: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67273: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67274: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67275: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67276: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67277: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67278: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67271: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67272: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67273: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67274: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67275: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67276: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67277: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67278: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67279: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67272: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67273: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67274: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67275: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67276: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67277: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67278: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67279: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67280: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67273: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67274: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67275: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67276: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67277: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67278: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67279: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67280: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67281: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67274: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67275: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67276: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67277: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67278: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67279: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67280: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67281: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67282: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67275: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67276: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67277: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67278: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67279: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67280: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67281: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67282: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67283: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67276: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67277: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67278: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67279: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67280: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67281: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67282: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67283: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67284: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67277: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67278: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67279: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67280: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67281: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67282: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67283: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67284: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67285: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67278: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67279: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67280: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67281: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67282: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67283: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67284: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67285: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67286: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67279: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67280: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67281: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67282: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67283: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67284: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67285: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67286: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67287: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67280: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67281: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67282: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67283: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67284: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67285: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67286: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67287: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67288:
67281: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67282: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67283: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67284: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67285: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67286: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67287: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67288:
67289: ELSE null
67282: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67283: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67284: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67285: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67286: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67287: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67288:
67289: ELSE null
67290: END object_name
67283: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67284: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67285: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67286: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67287: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
67288:
67289: ELSE null
67290: END object_name
67291: , CASE r
67401:
67402: ELSE null
67403: END source_meaning
67404: FROM xla_events_gt xet
67405: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67406: , fnd_lookup_values fvl7
67407: , fnd_lookup_values fvl66
67408: , fnd_lookup_values fvl67
67409: , fnd_lookup_values fvl85
67571: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
67572: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
67573: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
67574:
67575: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
67576: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
67577: TYPE t_array_source_16 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_COLL_CCID%TYPE INDEX BY BINARY_INTEGER;
67578: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
67579: TYPE t_array_source_19 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_COLL_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
67572: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
67573: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
67574:
67575: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
67576: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
67577: TYPE t_array_source_16 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_COLL_CCID%TYPE INDEX BY BINARY_INTEGER;
67578: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
67579: TYPE t_array_source_19 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_COLL_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
67580: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67573: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
67574:
67575: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
67576: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
67577: TYPE t_array_source_16 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_COLL_CCID%TYPE INDEX BY BINARY_INTEGER;
67578: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
67579: TYPE t_array_source_19 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_COLL_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
67580: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67581: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
67574:
67575: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
67576: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
67577: TYPE t_array_source_16 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_COLL_CCID%TYPE INDEX BY BINARY_INTEGER;
67578: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
67579: TYPE t_array_source_19 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_COLL_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
67580: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67581: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
67582: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67575: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
67576: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
67577: TYPE t_array_source_16 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_COLL_CCID%TYPE INDEX BY BINARY_INTEGER;
67578: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
67579: TYPE t_array_source_19 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_COLL_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
67580: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67581: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
67582: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67583: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67576: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
67577: TYPE t_array_source_16 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_COLL_CCID%TYPE INDEX BY BINARY_INTEGER;
67578: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
67579: TYPE t_array_source_19 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_COLL_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
67580: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67581: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
67582: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67583: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67584: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
67577: TYPE t_array_source_16 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_COLL_CCID%TYPE INDEX BY BINARY_INTEGER;
67578: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
67579: TYPE t_array_source_19 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_COLL_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
67580: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67581: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
67582: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67583: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67584: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
67585: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67578: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
67579: TYPE t_array_source_19 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_COLL_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
67580: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67581: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
67582: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67583: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67584: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
67585: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67586: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
67579: TYPE t_array_source_19 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_COLL_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
67580: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67581: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
67582: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67583: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67584: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
67585: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67586: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
67587: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67580: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
67581: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
67582: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67583: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67584: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
67585: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67586: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
67587: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67588: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
67581: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
67582: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67583: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67584: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
67585: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67586: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
67587: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67588: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
67589: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67582: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67583: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67584: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
67585: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67586: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
67587: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67588: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
67589: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67590: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67583: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67584: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
67585: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67586: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
67587: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67588: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
67589: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67590: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67591: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67584: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
67585: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67586: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
67587: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67588: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
67589: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67590: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67591: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67592: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67585: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
67586: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
67587: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67588: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
67589: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67590: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67591: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67592: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67593: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
67586: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
67587: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67588: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
67589: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67590: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67591: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67592: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67593: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
67594: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67587: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67588: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
67589: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67590: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67591: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67592: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67593: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
67594: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67595: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67588: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
67589: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67590: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67591: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67592: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67593: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
67594: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67595: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67596: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
67589: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
67590: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67591: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67592: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67593: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
67594: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67595: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67596: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
67597:
67590: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
67591: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67592: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67593: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
67594: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67595: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67596: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
67597:
67598: l_array_source_4 t_array_source_4;
67591: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
67592: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67593: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
67594: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67595: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67596: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
67597:
67598: l_array_source_4 t_array_source_4;
67599: l_array_source_5 t_array_source_5;
67592: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
67593: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
67594: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
67595: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
67596: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
67597:
67598: l_array_source_4 t_array_source_4;
67599: l_array_source_5 t_array_source_5;
67600: l_array_source_6 t_array_source_6;
67753: , l4.JLBR_REVERSED_DIST_LINK_TYPE source_84
67754: , l4.JLBR_BANK_OCC_TYPE source_85
67755: , fvl85.meaning source_85_meaning
67756: FROM xla_events_gt xet
67757: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67758: , fnd_lookup_values fvl7
67759: , fnd_lookup_values fvl66
67760: , fnd_lookup_values fvl67
67761: , fnd_lookup_values fvl85
73369: FROM (
73370: SELECT xet.event_id event_id
73371: , l4.line_number line_number
73372: , CASE r
73373: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73374: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73375: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73376: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73377: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73370: SELECT xet.event_id event_id
73371: , l4.line_number line_number
73372: , CASE r
73373: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73374: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73375: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73376: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73377: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73378: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73371: , l4.line_number line_number
73372: , CASE r
73373: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73374: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73375: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73376: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73377: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73378: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73379: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73372: , CASE r
73373: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73374: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73375: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73376: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73377: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73378: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73379: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73380: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73373: WHEN 1 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73374: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73375: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73376: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73377: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73378: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73379: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73380: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73381: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73374: WHEN 2 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73375: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73376: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73377: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73378: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73379: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73380: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73381: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73382: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73375: WHEN 3 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73376: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73377: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73378: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73379: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73380: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73381: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73382: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73383: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73376: WHEN 4 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73377: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73378: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73379: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73380: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73381: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73382: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73383: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73384: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73377: WHEN 5 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73378: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73379: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73380: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73381: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73382: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73383: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73384: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73385: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73378: WHEN 6 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73379: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73380: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73381: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73382: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73383: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73384: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73385: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73386: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73379: WHEN 7 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73380: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73381: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73382: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73383: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73384: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73385: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73386: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73387: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73380: WHEN 8 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73381: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73382: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73383: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73384: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73385: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73386: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73387: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73388: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73381: WHEN 9 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73382: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73383: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73384: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73385: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73386: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73387: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73388: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73389: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73382: WHEN 10 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73383: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73384: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73385: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73386: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73387: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73388: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73389: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73390: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73383: WHEN 11 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73384: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73385: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73386: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73387: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73388: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73389: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73390: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73391: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73384: WHEN 12 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73385: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73386: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73387: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73388: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73389: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73390: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73391: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73392: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73385: WHEN 13 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73386: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73387: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73388: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73389: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73390: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73391: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73392: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73393: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73386: WHEN 14 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73387: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73388: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73389: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73390: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73391: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73392: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73393: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73394: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73387: WHEN 15 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73388: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73389: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73390: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73391: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73392: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73393: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73394: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73395: WHEN 23 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73388: WHEN 16 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73389: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73390: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73391: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73392: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73393: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73394: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73395: WHEN 23 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73396:
73389: WHEN 17 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73390: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73391: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73392: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73393: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73394: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73395: WHEN 23 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73396:
73397: ELSE null
73390: WHEN 18 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73391: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73392: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73393: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73394: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73395: WHEN 23 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73396:
73397: ELSE null
73398: END object_name
73391: WHEN 19 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73392: WHEN 20 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73393: WHEN 21 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73394: WHEN 22 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73395: WHEN 23 THEN 'JL_BR_AR_COLL_DOC_DISTS_L_V'
73396:
73397: ELSE null
73398: END object_name
73399: , CASE r
73513:
73514: ELSE null
73515: END source_meaning
73516: FROM xla_events_gt xet
73517: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73518: , fnd_lookup_values fvl7
73519: , fnd_lookup_values fvl66
73520: , fnd_lookup_values fvl67
73521: , fnd_lookup_values fvl85
73683: TYPE t_array_source_114 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_EXCHG_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
73684: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73685: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
73686:
73687: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
73688: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73689: TYPE t_array_source_17 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_DISC_CCID%TYPE INDEX BY BINARY_INTEGER;
73690: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
73691: TYPE t_array_source_20 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_DISC_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
73684: TYPE t_array_source_115 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_GL_DATE%TYPE INDEX BY BINARY_INTEGER;
73685: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
73686:
73687: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
73688: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73689: TYPE t_array_source_17 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_DISC_CCID%TYPE INDEX BY BINARY_INTEGER;
73690: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
73691: TYPE t_array_source_20 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_DISC_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
73692: TYPE t_array_source_21 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_FACT_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73685: TYPE t_array_source_116 IS TABLE OF JL_BR_AR_COLL_OCC_DOCS_H_V.JLBR_TRANSFER_TO_GL_FLAG%TYPE INDEX BY BINARY_INTEGER;
73686:
73687: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
73688: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73689: TYPE t_array_source_17 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_DISC_CCID%TYPE INDEX BY BINARY_INTEGER;
73690: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
73691: TYPE t_array_source_20 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_DISC_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
73692: TYPE t_array_source_21 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_FACT_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73693: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73686:
73687: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
73688: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73689: TYPE t_array_source_17 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_DISC_CCID%TYPE INDEX BY BINARY_INTEGER;
73690: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
73691: TYPE t_array_source_20 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_DISC_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
73692: TYPE t_array_source_21 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_FACT_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73693: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73694: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
73687: TYPE t_array_source_7 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BORDERO_TYPE%TYPE INDEX BY BINARY_INTEGER;
73688: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73689: TYPE t_array_source_17 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_DISC_CCID%TYPE INDEX BY BINARY_INTEGER;
73690: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
73691: TYPE t_array_source_20 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_DISC_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
73692: TYPE t_array_source_21 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_FACT_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73693: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73694: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
73695: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73688: TYPE t_array_source_15 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BANK_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73689: TYPE t_array_source_17 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_DISC_CCID%TYPE INDEX BY BINARY_INTEGER;
73690: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
73691: TYPE t_array_source_20 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_DISC_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
73692: TYPE t_array_source_21 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_FACT_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73693: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73694: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
73695: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73696: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73689: TYPE t_array_source_17 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_BIL_UND_DISC_CCID%TYPE INDEX BY BINARY_INTEGER;
73690: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
73691: TYPE t_array_source_20 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_DISC_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
73692: TYPE t_array_source_21 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_FACT_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73693: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73694: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
73695: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73696: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73697: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
73690: TYPE t_array_source_18 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_CASH_CCID%TYPE INDEX BY BINARY_INTEGER;
73691: TYPE t_array_source_20 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_DISC_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
73692: TYPE t_array_source_21 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_FACT_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73693: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73694: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
73695: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73696: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73697: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
73698: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73691: TYPE t_array_source_20 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_DISC_ENDRSMNT_CCID%TYPE INDEX BY BINARY_INTEGER;
73692: TYPE t_array_source_21 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_FACT_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73693: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73694: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
73695: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73696: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73697: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
73698: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73699: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
73692: TYPE t_array_source_21 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CD_FACT_CHARGES_CCID%TYPE INDEX BY BINARY_INTEGER;
73693: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73694: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
73695: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73696: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73697: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
73698: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73699: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
73700: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73693: TYPE t_array_source_66 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73694: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
73695: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73696: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73697: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
73698: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73699: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
73700: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73701: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
73694: TYPE t_array_source_67 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCT_REVERSING_OPTN%TYPE INDEX BY BINARY_INTEGER;
73695: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73696: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73697: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
73698: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73699: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
73700: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73701: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
73702: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73695: TYPE t_array_source_69 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73696: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73697: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
73698: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73699: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
73700: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73701: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
73702: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73703: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73696: TYPE t_array_source_71 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73697: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
73698: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73699: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
73700: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73701: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
73702: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73703: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73704: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73697: TYPE t_array_source_72 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_DOCUMENT_ID%TYPE INDEX BY BINARY_INTEGER;
73698: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73699: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
73700: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73701: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
73702: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73703: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73704: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73705: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73698: TYPE t_array_source_73 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_PRIOR_OCCURRENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73699: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
73700: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73701: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
73702: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73703: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73704: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73705: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73706: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73699: TYPE t_array_source_74 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
73700: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73701: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
73702: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73703: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73704: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73705: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73706: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73707: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73700: TYPE t_array_source_75 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_DISTRIBUTION_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73701: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
73702: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73703: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73704: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73705: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73706: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73707: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73708: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73701: TYPE t_array_source_76 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_AMT%TYPE INDEX BY BINARY_INTEGER;
73702: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73703: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73704: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73705: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73706: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73707: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73708: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73709: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
73702: TYPE t_array_source_77 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
73703: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73704: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73705: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73706: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73707: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73708: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73709: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
73710:
73703: TYPE t_array_source_78 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73704: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73705: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73706: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73707: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73708: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73709: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
73710:
73711: l_array_source_4 t_array_source_4;
73704: TYPE t_array_source_79 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73705: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73706: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73707: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73708: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73709: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
73710:
73711: l_array_source_4 t_array_source_4;
73712: l_array_source_5 t_array_source_5;
73705: TYPE t_array_source_80 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_CONVERSION_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
73706: TYPE t_array_source_81 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73707: TYPE t_array_source_83 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73708: TYPE t_array_source_84 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_REVERSED_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
73709: TYPE t_array_source_85 IS TABLE OF JL_BR_AR_COLL_DOC_DISTS_L_V.JLBR_BANK_OCC_TYPE%TYPE INDEX BY BINARY_INTEGER;
73710:
73711: l_array_source_4 t_array_source_4;
73712: l_array_source_5 t_array_source_5;
73713: l_array_source_6 t_array_source_6;
73868: , l4.JLBR_REVERSED_DIST_LINK_TYPE source_84
73869: , l4.JLBR_BANK_OCC_TYPE source_85
73870: , fvl85.meaning source_85_meaning
73871: FROM xla_events_gt xet
73872: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73873: , fnd_lookup_values fvl7
73874: , fnd_lookup_values fvl66
73875: , fnd_lookup_values fvl67
73876: , fnd_lookup_values fvl85