DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000007_PKG dependencies on FND_LOOKUP_VALUES

Line 138228: , fnd_lookup_values fvl12

138224: ELSE null
138225: END source_meaning
138226: FROM xla_events_gt xet
138227: , CST_XLA_WIP_HEADERS_V h1
138228: , fnd_lookup_values fvl12
138229: , fnd_lookup_values fvl38
138230: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
138231: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
138232: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 138229: , fnd_lookup_values fvl38

138225: END source_meaning
138226: FROM xla_events_gt xet
138227: , CST_XLA_WIP_HEADERS_V h1
138228: , fnd_lookup_values fvl12
138229: , fnd_lookup_values fvl38
138230: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
138231: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
138232: AND xet.event_class_code = C_EVENT_CLASS_CODE
138233: AND h1.event_id = xet.event_id

Line 138490: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

138486: l_balance_type_code VARCHAR2(1) :=NULL;
138487: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
138488:
138489: --
138490: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
138491: --
138492:
138493: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
138494: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 138560: , fnd_lookup_values fvl12

138556: , h1.TRANSFER_TO_GL_INDICATOR source_38
138557: , fvl38.meaning source_38_meaning
138558: FROM xla_events_gt xet
138559: , CST_XLA_WIP_HEADERS_V h1
138560: , fnd_lookup_values fvl12
138561: , fnd_lookup_values fvl38
138562: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
138563: and xet.event_class_code = C_EVENT_CLASS_CODE
138564: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 138561: , fnd_lookup_values fvl38

138557: , fvl38.meaning source_38_meaning
138558: FROM xla_events_gt xet
138559: , CST_XLA_WIP_HEADERS_V h1
138560: , fnd_lookup_values fvl12
138561: , fnd_lookup_values fvl38
138562: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
138563: and xet.event_class_code = C_EVENT_CLASS_CODE
138564: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
138565: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 139526: , fnd_lookup_values fvl12

139522: ELSE null
139523: END source_meaning
139524: FROM xla_events_gt xet
139525: , CST_XLA_AWO_HEADERS_V h1
139526: , fnd_lookup_values fvl12
139527: , fnd_lookup_values fvl38
139528: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
139529: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
139530: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 139527: , fnd_lookup_values fvl38

139523: END source_meaning
139524: FROM xla_events_gt xet
139525: , CST_XLA_AWO_HEADERS_V h1
139526: , fnd_lookup_values fvl12
139527: , fnd_lookup_values fvl38
139528: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
139529: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
139530: AND xet.event_class_code = C_EVENT_CLASS_CODE
139531: AND h1.event_id = xet.event_id

Line 139798: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

139794: l_balance_type_code VARCHAR2(1) :=NULL;
139795: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
139796:
139797: --
139798: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
139799: --
139800:
139801: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
139802: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 139872: , fnd_lookup_values fvl12

139868: , h1.TRANSFER_TO_GL_INDICATOR source_38
139869: , fvl38.meaning source_38_meaning
139870: FROM xla_events_gt xet
139871: , CST_XLA_AWO_HEADERS_V h1
139872: , fnd_lookup_values fvl12
139873: , fnd_lookup_values fvl38
139874: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
139875: and xet.event_class_code = C_EVENT_CLASS_CODE
139876: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 139873: , fnd_lookup_values fvl38

139869: , fvl38.meaning source_38_meaning
139870: FROM xla_events_gt xet
139871: , CST_XLA_AWO_HEADERS_V h1
139872: , fnd_lookup_values fvl12
139873: , fnd_lookup_values fvl38
139874: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
139875: and xet.event_class_code = C_EVENT_CLASS_CODE
139876: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
139877: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 140793: , fnd_lookup_values fvl12

140789: ELSE null
140790: END source_meaning
140791: FROM xla_events_gt xet
140792: , CST_XLA_INV_HEADERS_V h1
140793: , fnd_lookup_values fvl12
140794: , fnd_lookup_values fvl38
140795: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
140796: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
140797: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 140794: , fnd_lookup_values fvl38

140790: END source_meaning
140791: FROM xla_events_gt xet
140792: , CST_XLA_INV_HEADERS_V h1
140793: , fnd_lookup_values fvl12
140794: , fnd_lookup_values fvl38
140795: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
140796: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
140797: AND xet.event_class_code = C_EVENT_CLASS_CODE
140798: AND h1.event_id = xet.event_id

Line 141075: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

141071: l_balance_type_code VARCHAR2(1) :=NULL;
141072: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
141073:
141074: --
141075: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
141076: --
141077:
141078: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
141079: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 141141: , fnd_lookup_values fvl12

141137: , h1.TRANSFER_TO_GL_INDICATOR source_38
141138: , fvl38.meaning source_38_meaning
141139: FROM xla_events_gt xet
141140: , CST_XLA_INV_HEADERS_V h1
141141: , fnd_lookup_values fvl12
141142: , fnd_lookup_values fvl38
141143: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
141144: and xet.event_class_code = C_EVENT_CLASS_CODE
141145: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 141142: , fnd_lookup_values fvl38

141138: , fvl38.meaning source_38_meaning
141139: FROM xla_events_gt xet
141140: , CST_XLA_INV_HEADERS_V h1
141141: , fnd_lookup_values fvl12
141142: , fnd_lookup_values fvl38
141143: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
141144: and xet.event_class_code = C_EVENT_CLASS_CODE
141145: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
141146: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 142161: , fnd_lookup_values fvl12

142157: , CST_XLA_RCV_REF_V h3
142158: , PO_DISTS_REF_V h4
142159: , PO_HEADERS_REF_V h5
142160: , PSA_CST_XLA_UPG_V h6
142161: , fnd_lookup_values fvl12
142162: , fnd_lookup_values fvl38
142163: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
142164: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
142165: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 142162: , fnd_lookup_values fvl38

142158: , PO_DISTS_REF_V h4
142159: , PO_HEADERS_REF_V h5
142160: , PSA_CST_XLA_UPG_V h6
142161: , fnd_lookup_values fvl12
142162: , fnd_lookup_values fvl38
142163: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
142164: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
142165: AND xet.event_class_code = C_EVENT_CLASS_CODE
142166: AND h1.event_id = xet.event_id

Line 142423: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

142419: l_balance_type_code VARCHAR2(1) :=NULL;
142420: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
142421:
142422: --
142423: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
142424: --
142425:
142426: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
142427: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 142527: , fnd_lookup_values fvl12

142523: , CST_XLA_RCV_REF_V h3
142524: , PO_DISTS_REF_V h4
142525: , PO_HEADERS_REF_V h5
142526: , PSA_CST_XLA_UPG_V h6
142527: , fnd_lookup_values fvl12
142528: , fnd_lookup_values fvl38
142529: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
142530: and xet.event_class_code = C_EVENT_CLASS_CODE
142531: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 142528: , fnd_lookup_values fvl38

142524: , PO_DISTS_REF_V h4
142525: , PO_HEADERS_REF_V h5
142526: , PSA_CST_XLA_UPG_V h6
142527: , fnd_lookup_values fvl12
142528: , fnd_lookup_values fvl38
142529: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
142530: and xet.event_class_code = C_EVENT_CLASS_CODE
142531: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
142532: AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h4.po_header_id (+) AND h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 143482: , fnd_lookup_values fvl12

143478: , CST_XLA_INV_REF_V h3
143479: , PO_REQ_DISTS_REF_V h4
143480: , PO_REQ_HEADERS_REF_V h5
143481: , PSA_CST_XLA_UPG_V h6
143482: , fnd_lookup_values fvl12
143483: , fnd_lookup_values fvl38
143484: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
143485: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143486: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 143483: , fnd_lookup_values fvl38

143479: , PO_REQ_DISTS_REF_V h4
143480: , PO_REQ_HEADERS_REF_V h5
143481: , PSA_CST_XLA_UPG_V h6
143482: , fnd_lookup_values fvl12
143483: , fnd_lookup_values fvl38
143484: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
143485: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143486: AND xet.event_class_code = C_EVENT_CLASS_CODE
143487: AND h1.event_id = xet.event_id

Line 143764: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

143760: l_balance_type_code VARCHAR2(1) :=NULL;
143761: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
143762:
143763: --
143764: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
143765: --
143766:
143767: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
143768: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 143864: , fnd_lookup_values fvl12

143860: , CST_XLA_INV_REF_V h3
143861: , PO_REQ_DISTS_REF_V h4
143862: , PO_REQ_HEADERS_REF_V h5
143863: , PSA_CST_XLA_UPG_V h6
143864: , fnd_lookup_values fvl12
143865: , fnd_lookup_values fvl38
143866: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
143867: and xet.event_class_code = C_EVENT_CLASS_CODE
143868: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 143865: , fnd_lookup_values fvl38

143861: , PO_REQ_DISTS_REF_V h4
143862: , PO_REQ_HEADERS_REF_V h5
143863: , PSA_CST_XLA_UPG_V h6
143864: , fnd_lookup_values fvl12
143865: , fnd_lookup_values fvl38
143866: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
143867: and xet.event_class_code = C_EVENT_CLASS_CODE
143868: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
143869: AND h3.ref_transaction_id = h1.transaction_id AND h3.BUS_FLOW_REQ_DIST_ID=h4.REQ_DISTRIBUTION_ID (+) AND h3.BUS_FLOW_REQ_ID = h5.REQ_ID (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 145038: , fnd_lookup_values fvl12

145034: ELSE null
145035: END source_meaning
145036: FROM xla_events_gt xet
145037: , CST_XLA_INV_HEADERS_V h1
145038: , fnd_lookup_values fvl12
145039: , fnd_lookup_values fvl38
145040: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
145041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145042: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 145039: , fnd_lookup_values fvl38

145035: END source_meaning
145036: FROM xla_events_gt xet
145037: , CST_XLA_INV_HEADERS_V h1
145038: , fnd_lookup_values fvl12
145039: , fnd_lookup_values fvl38
145040: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
145041: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145042: AND xet.event_class_code = C_EVENT_CLASS_CODE
145043: AND h1.event_id = xet.event_id

Line 145320: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

145316: l_balance_type_code VARCHAR2(1) :=NULL;
145317: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
145318:
145319: --
145320: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
145321: --
145322:
145323: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
145324: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 145386: , fnd_lookup_values fvl12

145382: , h1.TRANSFER_TO_GL_INDICATOR source_38
145383: , fvl38.meaning source_38_meaning
145384: FROM xla_events_gt xet
145385: , CST_XLA_INV_HEADERS_V h1
145386: , fnd_lookup_values fvl12
145387: , fnd_lookup_values fvl38
145388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
145389: and xet.event_class_code = C_EVENT_CLASS_CODE
145390: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 145387: , fnd_lookup_values fvl38

145383: , fvl38.meaning source_38_meaning
145384: FROM xla_events_gt xet
145385: , CST_XLA_INV_HEADERS_V h1
145386: , fnd_lookup_values fvl12
145387: , fnd_lookup_values fvl38
145388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
145389: and xet.event_class_code = C_EVENT_CLASS_CODE
145390: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
145391: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 146502: , fnd_lookup_values fvl12

146498: , CST_XLA_INV_REF_V h3
146499: , PO_REQ_DISTS_REF_V h4
146500: , PO_REQ_HEADERS_REF_V h5
146501: , PSA_CST_XLA_UPG_V h6
146502: , fnd_lookup_values fvl12
146503: , fnd_lookup_values fvl38
146504: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
146505: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
146506: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 146503: , fnd_lookup_values fvl38

146499: , PO_REQ_DISTS_REF_V h4
146500: , PO_REQ_HEADERS_REF_V h5
146501: , PSA_CST_XLA_UPG_V h6
146502: , fnd_lookup_values fvl12
146503: , fnd_lookup_values fvl38
146504: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
146505: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
146506: AND xet.event_class_code = C_EVENT_CLASS_CODE
146507: AND h1.event_id = xet.event_id

Line 146784: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

146780: l_balance_type_code VARCHAR2(1) :=NULL;
146781: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
146782:
146783: --
146784: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
146785: --
146786:
146787: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
146788: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 146884: , fnd_lookup_values fvl12

146880: , CST_XLA_INV_REF_V h3
146881: , PO_REQ_DISTS_REF_V h4
146882: , PO_REQ_HEADERS_REF_V h5
146883: , PSA_CST_XLA_UPG_V h6
146884: , fnd_lookup_values fvl12
146885: , fnd_lookup_values fvl38
146886: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
146887: and xet.event_class_code = C_EVENT_CLASS_CODE
146888: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 146885: , fnd_lookup_values fvl38

146881: , PO_REQ_DISTS_REF_V h4
146882: , PO_REQ_HEADERS_REF_V h5
146883: , PSA_CST_XLA_UPG_V h6
146884: , fnd_lookup_values fvl12
146885: , fnd_lookup_values fvl38
146886: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
146887: and xet.event_class_code = C_EVENT_CLASS_CODE
146888: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
146889: AND h3.ref_transaction_id = h1.transaction_id AND h3.BUS_FLOW_REQ_DIST_ID=h4.REQ_DISTRIBUTION_ID (+) AND h3.BUS_FLOW_REQ_ID = h5.REQ_ID (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 148019: , fnd_lookup_values fvl12

148015: ELSE null
148016: END source_meaning
148017: FROM xla_events_gt xet
148018: , CST_XLA_INV_HEADERS_V h1
148019: , fnd_lookup_values fvl12
148020: , fnd_lookup_values fvl38
148021: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
148022: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148023: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 148020: , fnd_lookup_values fvl38

148016: END source_meaning
148017: FROM xla_events_gt xet
148018: , CST_XLA_INV_HEADERS_V h1
148019: , fnd_lookup_values fvl12
148020: , fnd_lookup_values fvl38
148021: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
148022: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148023: AND xet.event_class_code = C_EVENT_CLASS_CODE
148024: AND h1.event_id = xet.event_id

Line 148301: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

148297: l_balance_type_code VARCHAR2(1) :=NULL;
148298: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
148299:
148300: --
148301: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
148302: --
148303:
148304: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148305: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 148367: , fnd_lookup_values fvl12

148363: , h1.TRANSFER_TO_GL_INDICATOR source_38
148364: , fvl38.meaning source_38_meaning
148365: FROM xla_events_gt xet
148366: , CST_XLA_INV_HEADERS_V h1
148367: , fnd_lookup_values fvl12
148368: , fnd_lookup_values fvl38
148369: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148370: and xet.event_class_code = C_EVENT_CLASS_CODE
148371: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 148368: , fnd_lookup_values fvl38

148364: , fvl38.meaning source_38_meaning
148365: FROM xla_events_gt xet
148366: , CST_XLA_INV_HEADERS_V h1
148367: , fnd_lookup_values fvl12
148368: , fnd_lookup_values fvl38
148369: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148370: and xet.event_class_code = C_EVENT_CLASS_CODE
148371: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
148372: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 149371: , fnd_lookup_values fvl12

149367: ELSE null
149368: END source_meaning
149369: FROM xla_events_gt xet
149370: , CST_XLA_INV_HEADERS_V h1
149371: , fnd_lookup_values fvl12
149372: , fnd_lookup_values fvl38
149373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
149374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
149375: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 149372: , fnd_lookup_values fvl38

149368: END source_meaning
149369: FROM xla_events_gt xet
149370: , CST_XLA_INV_HEADERS_V h1
149371: , fnd_lookup_values fvl12
149372: , fnd_lookup_values fvl38
149373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
149374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
149375: AND xet.event_class_code = C_EVENT_CLASS_CODE
149376: AND h1.event_id = xet.event_id

Line 149653: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

149649: l_balance_type_code VARCHAR2(1) :=NULL;
149650: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
149651:
149652: --
149653: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
149654: --
149655:
149656: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
149657: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 149719: , fnd_lookup_values fvl12

149715: , h1.TRANSFER_TO_GL_INDICATOR source_38
149716: , fvl38.meaning source_38_meaning
149717: FROM xla_events_gt xet
149718: , CST_XLA_INV_HEADERS_V h1
149719: , fnd_lookup_values fvl12
149720: , fnd_lookup_values fvl38
149721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
149722: and xet.event_class_code = C_EVENT_CLASS_CODE
149723: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 149720: , fnd_lookup_values fvl38

149716: , fvl38.meaning source_38_meaning
149717: FROM xla_events_gt xet
149718: , CST_XLA_INV_HEADERS_V h1
149719: , fnd_lookup_values fvl12
149720: , fnd_lookup_values fvl38
149721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
149722: and xet.event_class_code = C_EVENT_CLASS_CODE
149723: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
149724: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 150661: , fnd_lookup_values fvl12

150657: , CST_XLA_INV_REF_V h3
150658: , PO_REQ_DISTS_REF_V h4
150659: , PO_REQ_HEADERS_REF_V h5
150660: , PSA_CST_XLA_UPG_V h6
150661: , fnd_lookup_values fvl12
150662: , fnd_lookup_values fvl38
150663: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
150664: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150665: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 150662: , fnd_lookup_values fvl38

150658: , PO_REQ_DISTS_REF_V h4
150659: , PO_REQ_HEADERS_REF_V h5
150660: , PSA_CST_XLA_UPG_V h6
150661: , fnd_lookup_values fvl12
150662: , fnd_lookup_values fvl38
150663: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
150664: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150665: AND xet.event_class_code = C_EVENT_CLASS_CODE
150666: AND h1.event_id = xet.event_id

Line 150943: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

150939: l_balance_type_code VARCHAR2(1) :=NULL;
150940: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
150941:
150942: --
150943: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
150944: --
150945:
150946: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
150947: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 151043: , fnd_lookup_values fvl12

151039: , CST_XLA_INV_REF_V h3
151040: , PO_REQ_DISTS_REF_V h4
151041: , PO_REQ_HEADERS_REF_V h5
151042: , PSA_CST_XLA_UPG_V h6
151043: , fnd_lookup_values fvl12
151044: , fnd_lookup_values fvl38
151045: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151046: and xet.event_class_code = C_EVENT_CLASS_CODE
151047: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 151044: , fnd_lookup_values fvl38

151040: , PO_REQ_DISTS_REF_V h4
151041: , PO_REQ_HEADERS_REF_V h5
151042: , PSA_CST_XLA_UPG_V h6
151043: , fnd_lookup_values fvl12
151044: , fnd_lookup_values fvl38
151045: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151046: and xet.event_class_code = C_EVENT_CLASS_CODE
151047: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
151048: AND h3.ref_transaction_id = h1.transaction_id AND h3.BUS_FLOW_REQ_DIST_ID=h4.REQ_DISTRIBUTION_ID (+) AND h3.BUS_FLOW_REQ_ID = h5.REQ_ID (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 151983: , fnd_lookup_values fvl12

151979: ELSE null
151980: END source_meaning
151981: FROM xla_events_gt xet
151982: , CST_XLA_INV_HEADERS_V h1
151983: , fnd_lookup_values fvl12
151984: , fnd_lookup_values fvl38
151985: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
151986: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151987: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 151984: , fnd_lookup_values fvl38

151980: END source_meaning
151981: FROM xla_events_gt xet
151982: , CST_XLA_INV_HEADERS_V h1
151983: , fnd_lookup_values fvl12
151984: , fnd_lookup_values fvl38
151985: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
151986: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151987: AND xet.event_class_code = C_EVENT_CLASS_CODE
151988: AND h1.event_id = xet.event_id

Line 152265: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

152261: l_balance_type_code VARCHAR2(1) :=NULL;
152262: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
152263:
152264: --
152265: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
152266: --
152267:
152268: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
152269: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 152331: , fnd_lookup_values fvl12

152327: , h1.TRANSFER_TO_GL_INDICATOR source_38
152328: , fvl38.meaning source_38_meaning
152329: FROM xla_events_gt xet
152330: , CST_XLA_INV_HEADERS_V h1
152331: , fnd_lookup_values fvl12
152332: , fnd_lookup_values fvl38
152333: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
152334: and xet.event_class_code = C_EVENT_CLASS_CODE
152335: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 152332: , fnd_lookup_values fvl38

152328: , fvl38.meaning source_38_meaning
152329: FROM xla_events_gt xet
152330: , CST_XLA_INV_HEADERS_V h1
152331: , fnd_lookup_values fvl12
152332: , fnd_lookup_values fvl38
152333: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
152334: and xet.event_class_code = C_EVENT_CLASS_CODE
152335: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
152336: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 153393: , fnd_lookup_values fvl12

153389: ELSE null
153390: END source_meaning
153391: FROM xla_events_gt xet
153392: , CST_XLA_INV_HEADERS_V h1
153393: , fnd_lookup_values fvl12
153394: , fnd_lookup_values fvl38
153395: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
153396: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153397: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 153394: , fnd_lookup_values fvl38

153390: END source_meaning
153391: FROM xla_events_gt xet
153392: , CST_XLA_INV_HEADERS_V h1
153393: , fnd_lookup_values fvl12
153394: , fnd_lookup_values fvl38
153395: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
153396: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153397: AND xet.event_class_code = C_EVENT_CLASS_CODE
153398: AND h1.event_id = xet.event_id

Line 153675: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

153671: l_balance_type_code VARCHAR2(1) :=NULL;
153672: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
153673:
153674: --
153675: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153676: --
153677:
153678: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
153679: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 153741: , fnd_lookup_values fvl12

153737: , h1.TRANSFER_TO_GL_INDICATOR source_38
153738: , fvl38.meaning source_38_meaning
153739: FROM xla_events_gt xet
153740: , CST_XLA_INV_HEADERS_V h1
153741: , fnd_lookup_values fvl12
153742: , fnd_lookup_values fvl38
153743: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153744: and xet.event_class_code = C_EVENT_CLASS_CODE
153745: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 153742: , fnd_lookup_values fvl38

153738: , fvl38.meaning source_38_meaning
153739: FROM xla_events_gt xet
153740: , CST_XLA_INV_HEADERS_V h1
153741: , fnd_lookup_values fvl12
153742: , fnd_lookup_values fvl38
153743: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153744: and xet.event_class_code = C_EVENT_CLASS_CODE
153745: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
153746: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 154716: , fnd_lookup_values fvl12

154712: ELSE null
154713: END source_meaning
154714: FROM xla_events_gt xet
154715: , CST_XLA_INV_HEADERS_V h1
154716: , fnd_lookup_values fvl12
154717: , fnd_lookup_values fvl38
154718: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
154719: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154720: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 154717: , fnd_lookup_values fvl38

154713: END source_meaning
154714: FROM xla_events_gt xet
154715: , CST_XLA_INV_HEADERS_V h1
154716: , fnd_lookup_values fvl12
154717: , fnd_lookup_values fvl38
154718: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
154719: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154720: AND xet.event_class_code = C_EVENT_CLASS_CODE
154721: AND h1.event_id = xet.event_id

Line 154998: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

154994: l_balance_type_code VARCHAR2(1) :=NULL;
154995: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
154996:
154997: --
154998: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
154999: --
155000:
155001: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155002: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 155064: , fnd_lookup_values fvl12

155060: , h1.TRANSFER_TO_GL_INDICATOR source_38
155061: , fvl38.meaning source_38_meaning
155062: FROM xla_events_gt xet
155063: , CST_XLA_INV_HEADERS_V h1
155064: , fnd_lookup_values fvl12
155065: , fnd_lookup_values fvl38
155066: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
155067: and xet.event_class_code = C_EVENT_CLASS_CODE
155068: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 155065: , fnd_lookup_values fvl38

155061: , fvl38.meaning source_38_meaning
155062: FROM xla_events_gt xet
155063: , CST_XLA_INV_HEADERS_V h1
155064: , fnd_lookup_values fvl12
155065: , fnd_lookup_values fvl38
155066: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
155067: and xet.event_class_code = C_EVENT_CLASS_CODE
155068: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
155069: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 155952: , fnd_lookup_values fvl12

155948: ELSE null
155949: END source_meaning
155950: FROM xla_events_gt xet
155951: , CST_XLA_INV_HEADERS_V h1
155952: , fnd_lookup_values fvl12
155953: , fnd_lookup_values fvl38
155954: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
155955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155956: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 155953: , fnd_lookup_values fvl38

155949: END source_meaning
155950: FROM xla_events_gt xet
155951: , CST_XLA_INV_HEADERS_V h1
155952: , fnd_lookup_values fvl12
155953: , fnd_lookup_values fvl38
155954: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
155955: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155956: AND xet.event_class_code = C_EVENT_CLASS_CODE
155957: AND h1.event_id = xet.event_id

Line 156234: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

156230: l_balance_type_code VARCHAR2(1) :=NULL;
156231: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
156232:
156233: --
156234: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
156235: --
156236:
156237: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
156238: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 156300: , fnd_lookup_values fvl12

156296: , h1.TRANSFER_TO_GL_INDICATOR source_38
156297: , fvl38.meaning source_38_meaning
156298: FROM xla_events_gt xet
156299: , CST_XLA_INV_HEADERS_V h1
156300: , fnd_lookup_values fvl12
156301: , fnd_lookup_values fvl38
156302: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156303: and xet.event_class_code = C_EVENT_CLASS_CODE
156304: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 156301: , fnd_lookup_values fvl38

156297: , fvl38.meaning source_38_meaning
156298: FROM xla_events_gt xet
156299: , CST_XLA_INV_HEADERS_V h1
156300: , fnd_lookup_values fvl12
156301: , fnd_lookup_values fvl38
156302: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156303: and xet.event_class_code = C_EVENT_CLASS_CODE
156304: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
156305: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 157263: , fnd_lookup_values fvl12

157259: FROM xla_events_gt xet
157260: , CST_XLA_RCV_HEADERS_V h1
157261: , CST_XLA_RCV_REF_V h3
157262: , PO_DISTS_REF_V h4
157263: , fnd_lookup_values fvl12
157264: , fnd_lookup_values fvl38
157265: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
157266: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157267: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 157264: , fnd_lookup_values fvl38

157260: , CST_XLA_RCV_HEADERS_V h1
157261: , CST_XLA_RCV_REF_V h3
157262: , PO_DISTS_REF_V h4
157263: , fnd_lookup_values fvl12
157264: , fnd_lookup_values fvl38
157265: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
157266: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157267: AND xet.event_class_code = C_EVENT_CLASS_CODE
157268: AND h1.event_id = xet.event_id

Line 157525: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

157521: l_balance_type_code VARCHAR2(1) :=NULL;
157522: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
157523:
157524: --
157525: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
157526: --
157527:
157528: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
157529: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 157594: , fnd_lookup_values fvl12

157590: FROM xla_events_gt xet
157591: , CST_XLA_RCV_HEADERS_V h1
157592: , CST_XLA_RCV_REF_V h3
157593: , PO_DISTS_REF_V h4
157594: , fnd_lookup_values fvl12
157595: , fnd_lookup_values fvl38
157596: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157597: and xet.event_class_code = C_EVENT_CLASS_CODE
157598: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 157595: , fnd_lookup_values fvl38

157591: , CST_XLA_RCV_HEADERS_V h1
157592: , CST_XLA_RCV_REF_V h3
157593: , PO_DISTS_REF_V h4
157594: , fnd_lookup_values fvl12
157595: , fnd_lookup_values fvl38
157596: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157597: and xet.event_class_code = C_EVENT_CLASS_CODE
157598: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
157599: AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h4.po_header_id AND h3.po_distribution_id = h4.po_distribution_id AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 158527: , fnd_lookup_values fvl12

158523: FROM xla_events_gt xet
158524: , CST_XLA_RCV_HEADERS_V h1
158525: , CST_XLA_RCV_REF_V h3
158526: , PO_DISTS_REF_V h4
158527: , fnd_lookup_values fvl12
158528: , fnd_lookup_values fvl38
158529: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
158530: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158531: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 158528: , fnd_lookup_values fvl38

158524: , CST_XLA_RCV_HEADERS_V h1
158525: , CST_XLA_RCV_REF_V h3
158526: , PO_DISTS_REF_V h4
158527: , fnd_lookup_values fvl12
158528: , fnd_lookup_values fvl38
158529: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
158530: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158531: AND xet.event_class_code = C_EVENT_CLASS_CODE
158532: AND h1.event_id = xet.event_id

Line 158789: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

158785: l_balance_type_code VARCHAR2(1) :=NULL;
158786: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
158787:
158788: --
158789: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
158790: --
158791:
158792: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
158793: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 158861: , fnd_lookup_values fvl12

158857: FROM xla_events_gt xet
158858: , CST_XLA_RCV_HEADERS_V h1
158859: , CST_XLA_RCV_REF_V h3
158860: , PO_DISTS_REF_V h4
158861: , fnd_lookup_values fvl12
158862: , fnd_lookup_values fvl38
158863: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
158864: and xet.event_class_code = C_EVENT_CLASS_CODE
158865: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 158862: , fnd_lookup_values fvl38

158858: , CST_XLA_RCV_HEADERS_V h1
158859: , CST_XLA_RCV_REF_V h3
158860: , PO_DISTS_REF_V h4
158861: , fnd_lookup_values fvl12
158862: , fnd_lookup_values fvl38
158863: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
158864: and xet.event_class_code = C_EVENT_CLASS_CODE
158865: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
158866: AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h4.po_header_id AND h3.po_distribution_id = h4.po_distribution_id AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 159726: , fnd_lookup_values fvl12

159722: ELSE null
159723: END source_meaning
159724: FROM xla_events_gt xet
159725: , CST_XLA_INV_HEADERS_V h1
159726: , fnd_lookup_values fvl12
159727: , fnd_lookup_values fvl35
159728: , fnd_lookup_values fvl38
159729: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
159730: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 159727: , fnd_lookup_values fvl35

159723: END source_meaning
159724: FROM xla_events_gt xet
159725: , CST_XLA_INV_HEADERS_V h1
159726: , fnd_lookup_values fvl12
159727: , fnd_lookup_values fvl35
159728: , fnd_lookup_values fvl38
159729: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
159730: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159731: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 159728: , fnd_lookup_values fvl38

159724: FROM xla_events_gt xet
159725: , CST_XLA_INV_HEADERS_V h1
159726: , fnd_lookup_values fvl12
159727: , fnd_lookup_values fvl35
159728: , fnd_lookup_values fvl38
159729: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
159730: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159731: AND xet.event_class_code = C_EVENT_CLASS_CODE
159732: AND h1.event_id = xet.event_id

Line 160013: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

160009: l_balance_type_code VARCHAR2(1) :=NULL;
160010: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
160011:
160012: --
160013: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
160014: --
160015:
160016: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
160017: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 160084: , fnd_lookup_values fvl12

160080: , h1.TRANSFER_TO_GL_INDICATOR source_38
160081: , fvl38.meaning source_38_meaning
160082: FROM xla_events_gt xet
160083: , CST_XLA_INV_HEADERS_V h1
160084: , fnd_lookup_values fvl12
160085: , fnd_lookup_values fvl35
160086: , fnd_lookup_values fvl38
160087: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160088: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 160085: , fnd_lookup_values fvl35

160081: , fvl38.meaning source_38_meaning
160082: FROM xla_events_gt xet
160083: , CST_XLA_INV_HEADERS_V h1
160084: , fnd_lookup_values fvl12
160085: , fnd_lookup_values fvl35
160086: , fnd_lookup_values fvl38
160087: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160088: and xet.event_class_code = C_EVENT_CLASS_CODE
160089: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 160086: , fnd_lookup_values fvl38

160082: FROM xla_events_gt xet
160083: , CST_XLA_INV_HEADERS_V h1
160084: , fnd_lookup_values fvl12
160085: , fnd_lookup_values fvl35
160086: , fnd_lookup_values fvl38
160087: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160088: and xet.event_class_code = C_EVENT_CLASS_CODE
160089: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
160090: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 161043: , fnd_lookup_values fvl12

161039: ELSE null
161040: END source_meaning
161041: FROM xla_events_gt xet
161042: , CST_XLA_INV_HEADERS_V h1
161043: , fnd_lookup_values fvl12
161044: , fnd_lookup_values fvl38
161045: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
161046: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161047: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 161044: , fnd_lookup_values fvl38

161040: END source_meaning
161041: FROM xla_events_gt xet
161042: , CST_XLA_INV_HEADERS_V h1
161043: , fnd_lookup_values fvl12
161044: , fnd_lookup_values fvl38
161045: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
161046: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161047: AND xet.event_class_code = C_EVENT_CLASS_CODE
161048: AND h1.event_id = xet.event_id

Line 161325: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

161321: l_balance_type_code VARCHAR2(1) :=NULL;
161322: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
161323:
161324: --
161325: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
161326: --
161327:
161328: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
161329: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 161391: , fnd_lookup_values fvl12

161387: , h1.TRANSFER_TO_GL_INDICATOR source_38
161388: , fvl38.meaning source_38_meaning
161389: FROM xla_events_gt xet
161390: , CST_XLA_INV_HEADERS_V h1
161391: , fnd_lookup_values fvl12
161392: , fnd_lookup_values fvl38
161393: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161394: and xet.event_class_code = C_EVENT_CLASS_CODE
161395: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 161392: , fnd_lookup_values fvl38

161388: , fvl38.meaning source_38_meaning
161389: FROM xla_events_gt xet
161390: , CST_XLA_INV_HEADERS_V h1
161391: , fnd_lookup_values fvl12
161392: , fnd_lookup_values fvl38
161393: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161394: and xet.event_class_code = C_EVENT_CLASS_CODE
161395: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
161396: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 162294: , fnd_lookup_values fvl12

162290: ELSE null
162291: END source_meaning
162292: FROM xla_events_gt xet
162293: , CST_XLA_WIP_HEADERS_V h1
162294: , fnd_lookup_values fvl12
162295: , fnd_lookup_values fvl38
162296: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162298: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 162295: , fnd_lookup_values fvl38

162291: END source_meaning
162292: FROM xla_events_gt xet
162293: , CST_XLA_WIP_HEADERS_V h1
162294: , fnd_lookup_values fvl12
162295: , fnd_lookup_values fvl38
162296: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162297: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162298: AND xet.event_class_code = C_EVENT_CLASS_CODE
162299: AND h1.event_id = xet.event_id

Line 162556: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

162552: l_balance_type_code VARCHAR2(1) :=NULL;
162553: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
162554:
162555: --
162556: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162557: --
162558:
162559: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
162560: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 162623: , fnd_lookup_values fvl12

162619: , h1.TRANSFER_TO_GL_INDICATOR source_38
162620: , fvl38.meaning source_38_meaning
162621: FROM xla_events_gt xet
162622: , CST_XLA_WIP_HEADERS_V h1
162623: , fnd_lookup_values fvl12
162624: , fnd_lookup_values fvl38
162625: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162626: and xet.event_class_code = C_EVENT_CLASS_CODE
162627: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 162624: , fnd_lookup_values fvl38

162620: , fvl38.meaning source_38_meaning
162621: FROM xla_events_gt xet
162622: , CST_XLA_WIP_HEADERS_V h1
162623: , fnd_lookup_values fvl12
162624: , fnd_lookup_values fvl38
162625: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162626: and xet.event_class_code = C_EVENT_CLASS_CODE
162627: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
162628: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 163664: , fnd_lookup_values fvl12

163660: , CST_XLA_RCV_REF_V h3
163661: , PO_DISTS_REF_V h4
163662: , PO_HEADERS_REF_V h5
163663: , PSA_CST_XLA_PEA_UPG_V h6
163664: , fnd_lookup_values fvl12
163665: , fnd_lookup_values fvl38
163666: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
163667: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163668: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 163665: , fnd_lookup_values fvl38

163661: , PO_DISTS_REF_V h4
163662: , PO_HEADERS_REF_V h5
163663: , PSA_CST_XLA_PEA_UPG_V h6
163664: , fnd_lookup_values fvl12
163665: , fnd_lookup_values fvl38
163666: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
163667: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163668: AND xet.event_class_code = C_EVENT_CLASS_CODE
163669: AND h1.event_id = xet.event_id

Line 163926: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

163922: l_balance_type_code VARCHAR2(1) :=NULL;
163923: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
163924:
163925: --
163926: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
163927: --
163928:
163929: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
163930: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 164030: , fnd_lookup_values fvl12

164026: , CST_XLA_RCV_REF_V h3
164027: , PO_DISTS_REF_V h4
164028: , PO_HEADERS_REF_V h5
164029: , PSA_CST_XLA_PEA_UPG_V h6
164030: , fnd_lookup_values fvl12
164031: , fnd_lookup_values fvl38
164032: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
164033: and xet.event_class_code = C_EVENT_CLASS_CODE
164034: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 164031: , fnd_lookup_values fvl38

164027: , PO_DISTS_REF_V h4
164028: , PO_HEADERS_REF_V h5
164029: , PSA_CST_XLA_PEA_UPG_V h6
164030: , fnd_lookup_values fvl12
164031: , fnd_lookup_values fvl38
164032: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
164033: and xet.event_class_code = C_EVENT_CLASS_CODE
164034: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
164035: AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h4.po_header_id (+) AND h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.ref_rcv_accounting_event_id = h6.accounting_event_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 165031: , fnd_lookup_values fvl12

165027: , CST_XLA_INV_REF_V h3
165028: , PO_DISTS_REF_V h4
165029: , PO_HEADERS_REF_V h5
165030: , PSA_CST_XLA_UPG_V h6
165031: , fnd_lookup_values fvl12
165032: , fnd_lookup_values fvl38
165033: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
165034: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165035: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 165032: , fnd_lookup_values fvl38

165028: , PO_DISTS_REF_V h4
165029: , PO_HEADERS_REF_V h5
165030: , PSA_CST_XLA_UPG_V h6
165031: , fnd_lookup_values fvl12
165032: , fnd_lookup_values fvl38
165033: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
165034: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165035: AND xet.event_class_code = C_EVENT_CLASS_CODE
165036: AND h1.event_id = xet.event_id

Line 165313: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

165309: l_balance_type_code VARCHAR2(1) :=NULL;
165310: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
165311:
165312: --
165313: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165314: --
165315:
165316: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
165317: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 165413: , fnd_lookup_values fvl12

165409: , CST_XLA_INV_REF_V h3
165410: , PO_DISTS_REF_V h4
165411: , PO_HEADERS_REF_V h5
165412: , PSA_CST_XLA_UPG_V h6
165413: , fnd_lookup_values fvl12
165414: , fnd_lookup_values fvl38
165415: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165416: and xet.event_class_code = C_EVENT_CLASS_CODE
165417: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 165414: , fnd_lookup_values fvl38

165410: , PO_DISTS_REF_V h4
165411: , PO_HEADERS_REF_V h5
165412: , PSA_CST_XLA_UPG_V h6
165413: , fnd_lookup_values fvl12
165414: , fnd_lookup_values fvl38
165415: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165416: and xet.event_class_code = C_EVENT_CLASS_CODE
165417: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
165418: AND h3.ref_transaction_id = h1.transaction_id AND h3.txn_po_header_id = h4.po_header_id (+) AND h3.txn_po_distribution_id = h4.po_distribution_id (+) AND h3.txn_po_header_id = h5.po_header_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 166568: , fnd_lookup_values fvl12

166564: ELSE null
166565: END source_meaning
166566: FROM xla_events_gt xet
166567: , CST_XLA_RCV_HEADERS_V h1
166568: , fnd_lookup_values fvl12
166569: , fnd_lookup_values fvl38
166570: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
166571: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166572: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 166569: , fnd_lookup_values fvl38

166565: END source_meaning
166566: FROM xla_events_gt xet
166567: , CST_XLA_RCV_HEADERS_V h1
166568: , fnd_lookup_values fvl12
166569: , fnd_lookup_values fvl38
166570: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
166571: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166572: AND xet.event_class_code = C_EVENT_CLASS_CODE
166573: AND h1.event_id = xet.event_id

Line 166830: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

166826: l_balance_type_code VARCHAR2(1) :=NULL;
166827: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
166828:
166829: --
166830: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
166831: --
166832:
166833: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166834: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 166900: , fnd_lookup_values fvl12

166896: , h1.TRANSFER_TO_GL_INDICATOR source_38
166897: , fvl38.meaning source_38_meaning
166898: FROM xla_events_gt xet
166899: , CST_XLA_RCV_HEADERS_V h1
166900: , fnd_lookup_values fvl12
166901: , fnd_lookup_values fvl38
166902: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166903: and xet.event_class_code = C_EVENT_CLASS_CODE
166904: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 166901: , fnd_lookup_values fvl38

166897: , fvl38.meaning source_38_meaning
166898: FROM xla_events_gt xet
166899: , CST_XLA_RCV_HEADERS_V h1
166900: , fnd_lookup_values fvl12
166901: , fnd_lookup_values fvl38
166902: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166903: and xet.event_class_code = C_EVENT_CLASS_CODE
166904: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
166905: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 167890: , fnd_lookup_values fvl12

167886: ELSE null
167887: END source_meaning
167888: FROM xla_events_gt xet
167889: , CST_XLA_RCV_HEADERS_V h1
167890: , fnd_lookup_values fvl12
167891: , fnd_lookup_values fvl38
167892: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
167893: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167894: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 167891: , fnd_lookup_values fvl38

167887: END source_meaning
167888: FROM xla_events_gt xet
167889: , CST_XLA_RCV_HEADERS_V h1
167890: , fnd_lookup_values fvl12
167891: , fnd_lookup_values fvl38
167892: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
167893: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167894: AND xet.event_class_code = C_EVENT_CLASS_CODE
167895: AND h1.event_id = xet.event_id

Line 168152: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

168148: l_balance_type_code VARCHAR2(1) :=NULL;
168149: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
168150:
168151: --
168152: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168153: --
168154:
168155: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168156: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 168219: , fnd_lookup_values fvl12

168215: , h1.TRANSFER_TO_GL_INDICATOR source_38
168216: , fvl38.meaning source_38_meaning
168217: FROM xla_events_gt xet
168218: , CST_XLA_RCV_HEADERS_V h1
168219: , fnd_lookup_values fvl12
168220: , fnd_lookup_values fvl38
168221: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168222: and xet.event_class_code = C_EVENT_CLASS_CODE
168223: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 168220: , fnd_lookup_values fvl38

168216: , fvl38.meaning source_38_meaning
168217: FROM xla_events_gt xet
168218: , CST_XLA_RCV_HEADERS_V h1
168219: , fnd_lookup_values fvl12
168220: , fnd_lookup_values fvl38
168221: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168222: and xet.event_class_code = C_EVENT_CLASS_CODE
168223: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
168224: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 169122: , fnd_lookup_values fvl12

169118: ELSE null
169119: END source_meaning
169120: FROM xla_events_gt xet
169121: , CST_XLA_RCV_HEADERS_V h1
169122: , fnd_lookup_values fvl12
169123: , fnd_lookup_values fvl38
169124: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
169125: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169126: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 169123: , fnd_lookup_values fvl38

169119: END source_meaning
169120: FROM xla_events_gt xet
169121: , CST_XLA_RCV_HEADERS_V h1
169122: , fnd_lookup_values fvl12
169123: , fnd_lookup_values fvl38
169124: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
169125: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169126: AND xet.event_class_code = C_EVENT_CLASS_CODE
169127: AND h1.event_id = xet.event_id

Line 169384: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

169380: l_balance_type_code VARCHAR2(1) :=NULL;
169381: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
169382:
169383: --
169384: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
169385: --
169386:
169387: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
169388: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 169454: , fnd_lookup_values fvl12

169450: , h1.TRANSFER_TO_GL_INDICATOR source_38
169451: , fvl38.meaning source_38_meaning
169452: FROM xla_events_gt xet
169453: , CST_XLA_RCV_HEADERS_V h1
169454: , fnd_lookup_values fvl12
169455: , fnd_lookup_values fvl38
169456: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169457: and xet.event_class_code = C_EVENT_CLASS_CODE
169458: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 169455: , fnd_lookup_values fvl38

169451: , fvl38.meaning source_38_meaning
169452: FROM xla_events_gt xet
169453: , CST_XLA_RCV_HEADERS_V h1
169454: , fnd_lookup_values fvl12
169455: , fnd_lookup_values fvl38
169456: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
169457: and xet.event_class_code = C_EVENT_CLASS_CODE
169458: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
169459: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 170371: , fnd_lookup_values fvl12

170367: ELSE null
170368: END source_meaning
170369: FROM xla_events_gt xet
170370: , CST_XLA_INV_HEADERS_V h1
170371: , fnd_lookup_values fvl12
170372: , fnd_lookup_values fvl38
170373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
170374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170375: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 170372: , fnd_lookup_values fvl38

170368: END source_meaning
170369: FROM xla_events_gt xet
170370: , CST_XLA_INV_HEADERS_V h1
170371: , fnd_lookup_values fvl12
170372: , fnd_lookup_values fvl38
170373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
170374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170375: AND xet.event_class_code = C_EVENT_CLASS_CODE
170376: AND h1.event_id = xet.event_id

Line 170653: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

170649: l_balance_type_code VARCHAR2(1) :=NULL;
170650: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
170651:
170652: --
170653: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
170654: --
170655:
170656: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
170657: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 170719: , fnd_lookup_values fvl12

170715: , h1.TRANSFER_TO_GL_INDICATOR source_38
170716: , fvl38.meaning source_38_meaning
170717: FROM xla_events_gt xet
170718: , CST_XLA_INV_HEADERS_V h1
170719: , fnd_lookup_values fvl12
170720: , fnd_lookup_values fvl38
170721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
170722: and xet.event_class_code = C_EVENT_CLASS_CODE
170723: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 170720: , fnd_lookup_values fvl38

170716: , fvl38.meaning source_38_meaning
170717: FROM xla_events_gt xet
170718: , CST_XLA_INV_HEADERS_V h1
170719: , fnd_lookup_values fvl12
170720: , fnd_lookup_values fvl38
170721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
170722: and xet.event_class_code = C_EVENT_CLASS_CODE
170723: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
170724: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 171665: , fnd_lookup_values fvl12

171661: ELSE null
171662: END source_meaning
171663: FROM xla_events_gt xet
171664: , CST_XLA_INV_HEADERS_V h1
171665: , fnd_lookup_values fvl12
171666: , fnd_lookup_values fvl38
171667: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
171668: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171669: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 171666: , fnd_lookup_values fvl38

171662: END source_meaning
171663: FROM xla_events_gt xet
171664: , CST_XLA_INV_HEADERS_V h1
171665: , fnd_lookup_values fvl12
171666: , fnd_lookup_values fvl38
171667: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
171668: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171669: AND xet.event_type_code = C_EVENT_TYPE_CODE
171670: AND h1.event_id = xet.event_id

Line 171946: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

171942: l_balance_type_code VARCHAR2(1) :=NULL;
171943: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
171944:
171945: --
171946: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
171947: --
171948:
171949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
171950: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 172013: , fnd_lookup_values fvl12

172009: , h1.TRANSFER_TO_GL_INDICATOR source_38
172010: , fvl38.meaning source_38_meaning
172011: FROM xla_events_gt xet
172012: , CST_XLA_INV_HEADERS_V h1
172013: , fnd_lookup_values fvl12
172014: , fnd_lookup_values fvl38
172015: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
172016: and xet.event_type_code = C_EVENT_TYPE_CODE
172017: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 172014: , fnd_lookup_values fvl38

172010: , fvl38.meaning source_38_meaning
172011: FROM xla_events_gt xet
172012: , CST_XLA_INV_HEADERS_V h1
172013: , fnd_lookup_values fvl12
172014: , fnd_lookup_values fvl38
172015: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
172016: and xet.event_type_code = C_EVENT_TYPE_CODE
172017: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
172018: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 172959: , fnd_lookup_values fvl12

172955: ELSE null
172956: END source_meaning
172957: FROM xla_events_gt xet
172958: , CST_XLA_INV_HEADERS_V h1
172959: , fnd_lookup_values fvl12
172960: , fnd_lookup_values fvl38
172961: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
172962: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172963: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 172960: , fnd_lookup_values fvl38

172956: END source_meaning
172957: FROM xla_events_gt xet
172958: , CST_XLA_INV_HEADERS_V h1
172959: , fnd_lookup_values fvl12
172960: , fnd_lookup_values fvl38
172961: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
172962: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172963: AND xet.event_type_code = C_EVENT_TYPE_CODE
172964: AND h1.event_id = xet.event_id

Line 173240: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

173236: l_balance_type_code VARCHAR2(1) :=NULL;
173237: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
173238:
173239: --
173240: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
173241: --
173242:
173243: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
173244: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 173307: , fnd_lookup_values fvl12

173303: , h1.TRANSFER_TO_GL_INDICATOR source_38
173304: , fvl38.meaning source_38_meaning
173305: FROM xla_events_gt xet
173306: , CST_XLA_INV_HEADERS_V h1
173307: , fnd_lookup_values fvl12
173308: , fnd_lookup_values fvl38
173309: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
173310: and xet.event_type_code = C_EVENT_TYPE_CODE
173311: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 173308: , fnd_lookup_values fvl38

173304: , fvl38.meaning source_38_meaning
173305: FROM xla_events_gt xet
173306: , CST_XLA_INV_HEADERS_V h1
173307: , fnd_lookup_values fvl12
173308: , fnd_lookup_values fvl38
173309: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
173310: and xet.event_type_code = C_EVENT_TYPE_CODE
173311: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
173312: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 174195: , fnd_lookup_values fvl12

174191: ELSE null
174192: END source_meaning
174193: FROM xla_events_gt xet
174194: , CST_XLA_INV_HEADERS_V h1
174195: , fnd_lookup_values fvl12
174196: , fnd_lookup_values fvl38
174197: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
174198: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174199: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 174196: , fnd_lookup_values fvl38

174192: END source_meaning
174193: FROM xla_events_gt xet
174194: , CST_XLA_INV_HEADERS_V h1
174195: , fnd_lookup_values fvl12
174196: , fnd_lookup_values fvl38
174197: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
174198: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174199: AND xet.event_type_code = C_EVENT_TYPE_CODE
174200: AND h1.event_id = xet.event_id

Line 174476: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

174472: l_balance_type_code VARCHAR2(1) :=NULL;
174473: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
174474:
174475: --
174476: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
174477: --
174478:
174479: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174480: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 174543: , fnd_lookup_values fvl12

174539: , h1.TRANSFER_TO_GL_INDICATOR source_38
174540: , fvl38.meaning source_38_meaning
174541: FROM xla_events_gt xet
174542: , CST_XLA_INV_HEADERS_V h1
174543: , fnd_lookup_values fvl12
174544: , fnd_lookup_values fvl38
174545: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
174546: and xet.event_type_code = C_EVENT_TYPE_CODE
174547: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 174544: , fnd_lookup_values fvl38

174540: , fvl38.meaning source_38_meaning
174541: FROM xla_events_gt xet
174542: , CST_XLA_INV_HEADERS_V h1
174543: , fnd_lookup_values fvl12
174544: , fnd_lookup_values fvl38
174545: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
174546: and xet.event_type_code = C_EVENT_TYPE_CODE
174547: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
174548: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 175605: , fnd_lookup_values fvl12

175601: ELSE null
175602: END source_meaning
175603: FROM xla_events_gt xet
175604: , CST_XLA_INV_HEADERS_V h1
175605: , fnd_lookup_values fvl12
175606: , fnd_lookup_values fvl38
175607: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
175608: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175609: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 175606: , fnd_lookup_values fvl38

175602: END source_meaning
175603: FROM xla_events_gt xet
175604: , CST_XLA_INV_HEADERS_V h1
175605: , fnd_lookup_values fvl12
175606: , fnd_lookup_values fvl38
175607: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
175608: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175609: AND xet.event_type_code = C_EVENT_TYPE_CODE
175610: AND h1.event_id = xet.event_id

Line 175886: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

175882: l_balance_type_code VARCHAR2(1) :=NULL;
175883: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
175884:
175885: --
175886: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
175887: --
175888:
175889: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
175890: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 175953: , fnd_lookup_values fvl12

175949: , h1.TRANSFER_TO_GL_INDICATOR source_38
175950: , fvl38.meaning source_38_meaning
175951: FROM xla_events_gt xet
175952: , CST_XLA_INV_HEADERS_V h1
175953: , fnd_lookup_values fvl12
175954: , fnd_lookup_values fvl38
175955: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175956: and xet.event_type_code = C_EVENT_TYPE_CODE
175957: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 175954: , fnd_lookup_values fvl38

175950: , fvl38.meaning source_38_meaning
175951: FROM xla_events_gt xet
175952: , CST_XLA_INV_HEADERS_V h1
175953: , fnd_lookup_values fvl12
175954: , fnd_lookup_values fvl38
175955: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175956: and xet.event_type_code = C_EVENT_TYPE_CODE
175957: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
175958: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 177015: , fnd_lookup_values fvl12

177011: ELSE null
177012: END source_meaning
177013: FROM xla_events_gt xet
177014: , CST_XLA_INV_HEADERS_V h1
177015: , fnd_lookup_values fvl12
177016: , fnd_lookup_values fvl38
177017: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
177018: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177019: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 177016: , fnd_lookup_values fvl38

177012: END source_meaning
177013: FROM xla_events_gt xet
177014: , CST_XLA_INV_HEADERS_V h1
177015: , fnd_lookup_values fvl12
177016: , fnd_lookup_values fvl38
177017: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
177018: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177019: AND xet.event_type_code = C_EVENT_TYPE_CODE
177020: AND h1.event_id = xet.event_id

Line 177296: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

177292: l_balance_type_code VARCHAR2(1) :=NULL;
177293: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
177294:
177295: --
177296: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
177297: --
177298:
177299: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
177300: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 177363: , fnd_lookup_values fvl12

177359: , h1.TRANSFER_TO_GL_INDICATOR source_38
177360: , fvl38.meaning source_38_meaning
177361: FROM xla_events_gt xet
177362: , CST_XLA_INV_HEADERS_V h1
177363: , fnd_lookup_values fvl12
177364: , fnd_lookup_values fvl38
177365: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
177366: and xet.event_type_code = C_EVENT_TYPE_CODE
177367: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 177364: , fnd_lookup_values fvl38

177360: , fvl38.meaning source_38_meaning
177361: FROM xla_events_gt xet
177362: , CST_XLA_INV_HEADERS_V h1
177363: , fnd_lookup_values fvl12
177364: , fnd_lookup_values fvl38
177365: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
177366: and xet.event_type_code = C_EVENT_TYPE_CODE
177367: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
177368: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 178425: , fnd_lookup_values fvl12

178421: ELSE null
178422: END source_meaning
178423: FROM xla_events_gt xet
178424: , CST_XLA_INV_HEADERS_V h1
178425: , fnd_lookup_values fvl12
178426: , fnd_lookup_values fvl38
178427: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
178428: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
178429: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 178426: , fnd_lookup_values fvl38

178422: END source_meaning
178423: FROM xla_events_gt xet
178424: , CST_XLA_INV_HEADERS_V h1
178425: , fnd_lookup_values fvl12
178426: , fnd_lookup_values fvl38
178427: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
178428: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
178429: AND xet.event_type_code = C_EVENT_TYPE_CODE
178430: AND h1.event_id = xet.event_id

Line 178706: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

178702: l_balance_type_code VARCHAR2(1) :=NULL;
178703: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
178704:
178705: --
178706: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
178707: --
178708:
178709: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178710: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 178773: , fnd_lookup_values fvl12

178769: , h1.TRANSFER_TO_GL_INDICATOR source_38
178770: , fvl38.meaning source_38_meaning
178771: FROM xla_events_gt xet
178772: , CST_XLA_INV_HEADERS_V h1
178773: , fnd_lookup_values fvl12
178774: , fnd_lookup_values fvl38
178775: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
178776: and xet.event_type_code = C_EVENT_TYPE_CODE
178777: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 178774: , fnd_lookup_values fvl38

178770: , fvl38.meaning source_38_meaning
178771: FROM xla_events_gt xet
178772: , CST_XLA_INV_HEADERS_V h1
178773: , fnd_lookup_values fvl12
178774: , fnd_lookup_values fvl38
178775: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
178776: and xet.event_type_code = C_EVENT_TYPE_CODE
178777: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
178778: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 179835: , fnd_lookup_values fvl12

179831: ELSE null
179832: END source_meaning
179833: FROM xla_events_gt xet
179834: , CST_XLA_INV_HEADERS_V h1
179835: , fnd_lookup_values fvl12
179836: , fnd_lookup_values fvl38
179837: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
179838: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179839: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 179836: , fnd_lookup_values fvl38

179832: END source_meaning
179833: FROM xla_events_gt xet
179834: , CST_XLA_INV_HEADERS_V h1
179835: , fnd_lookup_values fvl12
179836: , fnd_lookup_values fvl38
179837: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
179838: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179839: AND xet.event_type_code = C_EVENT_TYPE_CODE
179840: AND h1.event_id = xet.event_id

Line 180116: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

180112: l_balance_type_code VARCHAR2(1) :=NULL;
180113: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
180114:
180115: --
180116: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
180117: --
180118:
180119: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
180120: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 180183: , fnd_lookup_values fvl12

180179: , h1.TRANSFER_TO_GL_INDICATOR source_38
180180: , fvl38.meaning source_38_meaning
180181: FROM xla_events_gt xet
180182: , CST_XLA_INV_HEADERS_V h1
180183: , fnd_lookup_values fvl12
180184: , fnd_lookup_values fvl38
180185: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
180186: and xet.event_type_code = C_EVENT_TYPE_CODE
180187: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 180184: , fnd_lookup_values fvl38

180180: , fvl38.meaning source_38_meaning
180181: FROM xla_events_gt xet
180182: , CST_XLA_INV_HEADERS_V h1
180183: , fnd_lookup_values fvl12
180184: , fnd_lookup_values fvl38
180185: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
180186: and xet.event_type_code = C_EVENT_TYPE_CODE
180187: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
180188: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 181245: , fnd_lookup_values fvl12

181241: ELSE null
181242: END source_meaning
181243: FROM xla_events_gt xet
181244: , CST_XLA_INV_HEADERS_V h1
181245: , fnd_lookup_values fvl12
181246: , fnd_lookup_values fvl38
181247: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
181248: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181249: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 181246: , fnd_lookup_values fvl38

181242: END source_meaning
181243: FROM xla_events_gt xet
181244: , CST_XLA_INV_HEADERS_V h1
181245: , fnd_lookup_values fvl12
181246: , fnd_lookup_values fvl38
181247: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
181248: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181249: AND xet.event_type_code = C_EVENT_TYPE_CODE
181250: AND h1.event_id = xet.event_id

Line 181526: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

181522: l_balance_type_code VARCHAR2(1) :=NULL;
181523: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
181524:
181525: --
181526: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
181527: --
181528:
181529: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
181530: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 181593: , fnd_lookup_values fvl12

181589: , h1.TRANSFER_TO_GL_INDICATOR source_38
181590: , fvl38.meaning source_38_meaning
181591: FROM xla_events_gt xet
181592: , CST_XLA_INV_HEADERS_V h1
181593: , fnd_lookup_values fvl12
181594: , fnd_lookup_values fvl38
181595: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
181596: and xet.event_type_code = C_EVENT_TYPE_CODE
181597: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 181594: , fnd_lookup_values fvl38

181590: , fvl38.meaning source_38_meaning
181591: FROM xla_events_gt xet
181592: , CST_XLA_INV_HEADERS_V h1
181593: , fnd_lookup_values fvl12
181594: , fnd_lookup_values fvl38
181595: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
181596: and xet.event_type_code = C_EVENT_TYPE_CODE
181597: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
181598: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 182655: , fnd_lookup_values fvl12

182651: ELSE null
182652: END source_meaning
182653: FROM xla_events_gt xet
182654: , CST_XLA_INV_HEADERS_V h1
182655: , fnd_lookup_values fvl12
182656: , fnd_lookup_values fvl38
182657: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
182658: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182659: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 182656: , fnd_lookup_values fvl38

182652: END source_meaning
182653: FROM xla_events_gt xet
182654: , CST_XLA_INV_HEADERS_V h1
182655: , fnd_lookup_values fvl12
182656: , fnd_lookup_values fvl38
182657: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
182658: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182659: AND xet.event_type_code = C_EVENT_TYPE_CODE
182660: AND h1.event_id = xet.event_id

Line 182936: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

182932: l_balance_type_code VARCHAR2(1) :=NULL;
182933: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
182934:
182935: --
182936: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
182937: --
182938:
182939: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
182940: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 183003: , fnd_lookup_values fvl12

182999: , h1.TRANSFER_TO_GL_INDICATOR source_38
183000: , fvl38.meaning source_38_meaning
183001: FROM xla_events_gt xet
183002: , CST_XLA_INV_HEADERS_V h1
183003: , fnd_lookup_values fvl12
183004: , fnd_lookup_values fvl38
183005: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183006: and xet.event_type_code = C_EVENT_TYPE_CODE
183007: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 183004: , fnd_lookup_values fvl38

183000: , fvl38.meaning source_38_meaning
183001: FROM xla_events_gt xet
183002: , CST_XLA_INV_HEADERS_V h1
183003: , fnd_lookup_values fvl12
183004: , fnd_lookup_values fvl38
183005: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183006: and xet.event_type_code = C_EVENT_TYPE_CODE
183007: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
183008: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 183891: , fnd_lookup_values fvl12

183887: ELSE null
183888: END source_meaning
183889: FROM xla_events_gt xet
183890: , CST_XLA_INV_HEADERS_V h1
183891: , fnd_lookup_values fvl12
183892: , fnd_lookup_values fvl38
183893: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
183894: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183895: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 183892: , fnd_lookup_values fvl38

183888: END source_meaning
183889: FROM xla_events_gt xet
183890: , CST_XLA_INV_HEADERS_V h1
183891: , fnd_lookup_values fvl12
183892: , fnd_lookup_values fvl38
183893: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
183894: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
183895: AND xet.event_type_code = C_EVENT_TYPE_CODE
183896: AND h1.event_id = xet.event_id

Line 184172: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

184168: l_balance_type_code VARCHAR2(1) :=NULL;
184169: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
184170:
184171: --
184172: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
184173: --
184174:
184175: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
184176: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 184239: , fnd_lookup_values fvl12

184235: , h1.TRANSFER_TO_GL_INDICATOR source_38
184236: , fvl38.meaning source_38_meaning
184237: FROM xla_events_gt xet
184238: , CST_XLA_INV_HEADERS_V h1
184239: , fnd_lookup_values fvl12
184240: , fnd_lookup_values fvl38
184241: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
184242: and xet.event_type_code = C_EVENT_TYPE_CODE
184243: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 184240: , fnd_lookup_values fvl38

184236: , fvl38.meaning source_38_meaning
184237: FROM xla_events_gt xet
184238: , CST_XLA_INV_HEADERS_V h1
184239: , fnd_lookup_values fvl12
184240: , fnd_lookup_values fvl38
184241: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
184242: and xet.event_type_code = C_EVENT_TYPE_CODE
184243: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
184244: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 185301: , fnd_lookup_values fvl12

185297: ELSE null
185298: END source_meaning
185299: FROM xla_events_gt xet
185300: , CST_XLA_INV_HEADERS_V h1
185301: , fnd_lookup_values fvl12
185302: , fnd_lookup_values fvl38
185303: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
185304: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185305: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 185302: , fnd_lookup_values fvl38

185298: END source_meaning
185299: FROM xla_events_gt xet
185300: , CST_XLA_INV_HEADERS_V h1
185301: , fnd_lookup_values fvl12
185302: , fnd_lookup_values fvl38
185303: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
185304: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185305: AND xet.event_type_code = C_EVENT_TYPE_CODE
185306: AND h1.event_id = xet.event_id

Line 185582: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

185578: l_balance_type_code VARCHAR2(1) :=NULL;
185579: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
185580:
185581: --
185582: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
185583: --
185584:
185585: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
185586: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 185649: , fnd_lookup_values fvl12

185645: , h1.TRANSFER_TO_GL_INDICATOR source_38
185646: , fvl38.meaning source_38_meaning
185647: FROM xla_events_gt xet
185648: , CST_XLA_INV_HEADERS_V h1
185649: , fnd_lookup_values fvl12
185650: , fnd_lookup_values fvl38
185651: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
185652: and xet.event_type_code = C_EVENT_TYPE_CODE
185653: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 185650: , fnd_lookup_values fvl38

185646: , fvl38.meaning source_38_meaning
185647: FROM xla_events_gt xet
185648: , CST_XLA_INV_HEADERS_V h1
185649: , fnd_lookup_values fvl12
185650: , fnd_lookup_values fvl38
185651: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
185652: and xet.event_type_code = C_EVENT_TYPE_CODE
185653: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
185654: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 186711: , fnd_lookup_values fvl12

186707: ELSE null
186708: END source_meaning
186709: FROM xla_events_gt xet
186710: , CST_XLA_INV_HEADERS_V h1
186711: , fnd_lookup_values fvl12
186712: , fnd_lookup_values fvl38
186713: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
186714: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186715: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 186712: , fnd_lookup_values fvl38

186708: END source_meaning
186709: FROM xla_events_gt xet
186710: , CST_XLA_INV_HEADERS_V h1
186711: , fnd_lookup_values fvl12
186712: , fnd_lookup_values fvl38
186713: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
186714: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186715: AND xet.event_type_code = C_EVENT_TYPE_CODE
186716: AND h1.event_id = xet.event_id

Line 186992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

186988: l_balance_type_code VARCHAR2(1) :=NULL;
186989: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
186990:
186991: --
186992: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
186993: --
186994:
186995: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
186996: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 187059: , fnd_lookup_values fvl12

187055: , h1.TRANSFER_TO_GL_INDICATOR source_38
187056: , fvl38.meaning source_38_meaning
187057: FROM xla_events_gt xet
187058: , CST_XLA_INV_HEADERS_V h1
187059: , fnd_lookup_values fvl12
187060: , fnd_lookup_values fvl38
187061: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187062: and xet.event_type_code = C_EVENT_TYPE_CODE
187063: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 187060: , fnd_lookup_values fvl38

187056: , fvl38.meaning source_38_meaning
187057: FROM xla_events_gt xet
187058: , CST_XLA_INV_HEADERS_V h1
187059: , fnd_lookup_values fvl12
187060: , fnd_lookup_values fvl38
187061: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187062: and xet.event_type_code = C_EVENT_TYPE_CODE
187063: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
187064: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 188034: , fnd_lookup_values fvl12

188030: ELSE null
188031: END source_meaning
188032: FROM xla_events_gt xet
188033: , CST_XLA_INV_HEADERS_V h1
188034: , fnd_lookup_values fvl12
188035: , fnd_lookup_values fvl38
188036: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
188037: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188038: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 188035: , fnd_lookup_values fvl38

188031: END source_meaning
188032: FROM xla_events_gt xet
188033: , CST_XLA_INV_HEADERS_V h1
188034: , fnd_lookup_values fvl12
188035: , fnd_lookup_values fvl38
188036: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
188037: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188038: AND xet.event_type_code = C_EVENT_TYPE_CODE
188039: AND h1.event_id = xet.event_id

Line 188315: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

188311: l_balance_type_code VARCHAR2(1) :=NULL;
188312: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
188313:
188314: --
188315: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
188316: --
188317:
188318: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
188319: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 188382: , fnd_lookup_values fvl12

188378: , h1.TRANSFER_TO_GL_INDICATOR source_38
188379: , fvl38.meaning source_38_meaning
188380: FROM xla_events_gt xet
188381: , CST_XLA_INV_HEADERS_V h1
188382: , fnd_lookup_values fvl12
188383: , fnd_lookup_values fvl38
188384: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
188385: and xet.event_type_code = C_EVENT_TYPE_CODE
188386: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 188383: , fnd_lookup_values fvl38

188379: , fvl38.meaning source_38_meaning
188380: FROM xla_events_gt xet
188381: , CST_XLA_INV_HEADERS_V h1
188382: , fnd_lookup_values fvl12
188383: , fnd_lookup_values fvl38
188384: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
188385: and xet.event_type_code = C_EVENT_TYPE_CODE
188386: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
188387: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 189357: , fnd_lookup_values fvl12

189353: ELSE null
189354: END source_meaning
189355: FROM xla_events_gt xet
189356: , CST_XLA_INV_HEADERS_V h1
189357: , fnd_lookup_values fvl12
189358: , fnd_lookup_values fvl38
189359: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
189360: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189361: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 189358: , fnd_lookup_values fvl38

189354: END source_meaning
189355: FROM xla_events_gt xet
189356: , CST_XLA_INV_HEADERS_V h1
189357: , fnd_lookup_values fvl12
189358: , fnd_lookup_values fvl38
189359: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
189360: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189361: AND xet.event_type_code = C_EVENT_TYPE_CODE
189362: AND h1.event_id = xet.event_id

Line 189638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

189634: l_balance_type_code VARCHAR2(1) :=NULL;
189635: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
189636:
189637: --
189638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
189639: --
189640:
189641: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
189642: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 189705: , fnd_lookup_values fvl12

189701: , h1.TRANSFER_TO_GL_INDICATOR source_38
189702: , fvl38.meaning source_38_meaning
189703: FROM xla_events_gt xet
189704: , CST_XLA_INV_HEADERS_V h1
189705: , fnd_lookup_values fvl12
189706: , fnd_lookup_values fvl38
189707: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
189708: and xet.event_type_code = C_EVENT_TYPE_CODE
189709: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 189706: , fnd_lookup_values fvl38

189702: , fvl38.meaning source_38_meaning
189703: FROM xla_events_gt xet
189704: , CST_XLA_INV_HEADERS_V h1
189705: , fnd_lookup_values fvl12
189706: , fnd_lookup_values fvl38
189707: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
189708: and xet.event_type_code = C_EVENT_TYPE_CODE
189709: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
189710: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 190622: , fnd_lookup_values fvl12

190618: ELSE null
190619: END source_meaning
190620: FROM xla_events_gt xet
190621: , CST_XLA_INV_HEADERS_V h1
190622: , fnd_lookup_values fvl12
190623: , fnd_lookup_values fvl38
190624: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
190625: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190626: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 190623: , fnd_lookup_values fvl38

190619: END source_meaning
190620: FROM xla_events_gt xet
190621: , CST_XLA_INV_HEADERS_V h1
190622: , fnd_lookup_values fvl12
190623: , fnd_lookup_values fvl38
190624: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
190625: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190626: AND xet.event_type_code = C_EVENT_TYPE_CODE
190627: AND h1.event_id = xet.event_id

Line 190903: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

190899: l_balance_type_code VARCHAR2(1) :=NULL;
190900: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
190901:
190902: --
190903: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
190904: --
190905:
190906: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
190907: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 190970: , fnd_lookup_values fvl12

190966: , h1.TRANSFER_TO_GL_INDICATOR source_38
190967: , fvl38.meaning source_38_meaning
190968: FROM xla_events_gt xet
190969: , CST_XLA_INV_HEADERS_V h1
190970: , fnd_lookup_values fvl12
190971: , fnd_lookup_values fvl38
190972: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
190973: and xet.event_type_code = C_EVENT_TYPE_CODE
190974: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 190971: , fnd_lookup_values fvl38

190967: , fvl38.meaning source_38_meaning
190968: FROM xla_events_gt xet
190969: , CST_XLA_INV_HEADERS_V h1
190970: , fnd_lookup_values fvl12
190971: , fnd_lookup_values fvl38
190972: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
190973: and xet.event_type_code = C_EVENT_TYPE_CODE
190974: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
190975: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 191858: , fnd_lookup_values fvl12

191854: ELSE null
191855: END source_meaning
191856: FROM xla_events_gt xet
191857: , CST_XLA_INV_HEADERS_V h1
191858: , fnd_lookup_values fvl12
191859: , fnd_lookup_values fvl38
191860: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
191861: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191862: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 191859: , fnd_lookup_values fvl38

191855: END source_meaning
191856: FROM xla_events_gt xet
191857: , CST_XLA_INV_HEADERS_V h1
191858: , fnd_lookup_values fvl12
191859: , fnd_lookup_values fvl38
191860: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
191861: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191862: AND xet.event_type_code = C_EVENT_TYPE_CODE
191863: AND h1.event_id = xet.event_id

Line 192139: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

192135: l_balance_type_code VARCHAR2(1) :=NULL;
192136: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
192137:
192138: --
192139: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
192140: --
192141:
192142: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
192143: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 192206: , fnd_lookup_values fvl12

192202: , h1.TRANSFER_TO_GL_INDICATOR source_38
192203: , fvl38.meaning source_38_meaning
192204: FROM xla_events_gt xet
192205: , CST_XLA_INV_HEADERS_V h1
192206: , fnd_lookup_values fvl12
192207: , fnd_lookup_values fvl38
192208: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
192209: and xet.event_type_code = C_EVENT_TYPE_CODE
192210: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 192207: , fnd_lookup_values fvl38

192203: , fvl38.meaning source_38_meaning
192204: FROM xla_events_gt xet
192205: , CST_XLA_INV_HEADERS_V h1
192206: , fnd_lookup_values fvl12
192207: , fnd_lookup_values fvl38
192208: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
192209: and xet.event_type_code = C_EVENT_TYPE_CODE
192210: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
192211: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 193094: , fnd_lookup_values fvl12

193090: ELSE null
193091: END source_meaning
193092: FROM xla_events_gt xet
193093: , CST_XLA_INV_HEADERS_V h1
193094: , fnd_lookup_values fvl12
193095: , fnd_lookup_values fvl38
193096: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
193097: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193098: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 193095: , fnd_lookup_values fvl38

193091: END source_meaning
193092: FROM xla_events_gt xet
193093: , CST_XLA_INV_HEADERS_V h1
193094: , fnd_lookup_values fvl12
193095: , fnd_lookup_values fvl38
193096: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
193097: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193098: AND xet.event_type_code = C_EVENT_TYPE_CODE
193099: AND h1.event_id = xet.event_id

Line 193375: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

193371: l_balance_type_code VARCHAR2(1) :=NULL;
193372: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
193373:
193374: --
193375: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
193376: --
193377:
193378: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
193379: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 193442: , fnd_lookup_values fvl12

193438: , h1.TRANSFER_TO_GL_INDICATOR source_38
193439: , fvl38.meaning source_38_meaning
193440: FROM xla_events_gt xet
193441: , CST_XLA_INV_HEADERS_V h1
193442: , fnd_lookup_values fvl12
193443: , fnd_lookup_values fvl38
193444: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
193445: and xet.event_type_code = C_EVENT_TYPE_CODE
193446: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 193443: , fnd_lookup_values fvl38

193439: , fvl38.meaning source_38_meaning
193440: FROM xla_events_gt xet
193441: , CST_XLA_INV_HEADERS_V h1
193442: , fnd_lookup_values fvl12
193443: , fnd_lookup_values fvl38
193444: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
193445: and xet.event_type_code = C_EVENT_TYPE_CODE
193446: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
193447: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 194350: , fnd_lookup_values fvl12

194346: ELSE null
194347: END source_meaning
194348: FROM xla_events_gt xet
194349: , CST_XLA_WIP_HEADERS_V h1
194350: , fnd_lookup_values fvl12
194351: , fnd_lookup_values fvl38
194352: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
194353: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194354: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 194351: , fnd_lookup_values fvl38

194347: END source_meaning
194348: FROM xla_events_gt xet
194349: , CST_XLA_WIP_HEADERS_V h1
194350: , fnd_lookup_values fvl12
194351: , fnd_lookup_values fvl38
194352: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
194353: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194354: AND xet.event_class_code = C_EVENT_CLASS_CODE
194355: AND h1.event_id = xet.event_id

Line 194612: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

194608: l_balance_type_code VARCHAR2(1) :=NULL;
194609: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
194610:
194611: --
194612: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
194613: --
194614:
194615: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194616: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 194682: , fnd_lookup_values fvl12

194678: , h1.TRANSFER_TO_GL_INDICATOR source_38
194679: , fvl38.meaning source_38_meaning
194680: FROM xla_events_gt xet
194681: , CST_XLA_WIP_HEADERS_V h1
194682: , fnd_lookup_values fvl12
194683: , fnd_lookup_values fvl38
194684: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194685: and xet.event_class_code = C_EVENT_CLASS_CODE
194686: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 194683: , fnd_lookup_values fvl38

194679: , fvl38.meaning source_38_meaning
194680: FROM xla_events_gt xet
194681: , CST_XLA_WIP_HEADERS_V h1
194682: , fnd_lookup_values fvl12
194683: , fnd_lookup_values fvl38
194684: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194685: and xet.event_class_code = C_EVENT_CLASS_CODE
194686: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
194687: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 195561: , fnd_lookup_values fvl12

195557: ELSE null
195558: END source_meaning
195559: FROM xla_events_gt xet
195560: , CST_XLA_WIP_HEADERS_V h1
195561: , fnd_lookup_values fvl12
195562: , fnd_lookup_values fvl38
195563: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
195564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195565: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 195562: , fnd_lookup_values fvl38

195558: END source_meaning
195559: FROM xla_events_gt xet
195560: , CST_XLA_WIP_HEADERS_V h1
195561: , fnd_lookup_values fvl12
195562: , fnd_lookup_values fvl38
195563: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
195564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195565: AND xet.event_class_code = C_EVENT_CLASS_CODE
195566: AND h1.event_id = xet.event_id

Line 195823: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

195819: l_balance_type_code VARCHAR2(1) :=NULL;
195820: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
195821:
195822: --
195823: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
195824: --
195825:
195826: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195827: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 195893: , fnd_lookup_values fvl12

195889: , h1.TRANSFER_TO_GL_INDICATOR source_38
195890: , fvl38.meaning source_38_meaning
195891: FROM xla_events_gt xet
195892: , CST_XLA_WIP_HEADERS_V h1
195893: , fnd_lookup_values fvl12
195894: , fnd_lookup_values fvl38
195895: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
195896: and xet.event_class_code = C_EVENT_CLASS_CODE
195897: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 195894: , fnd_lookup_values fvl38

195890: , fvl38.meaning source_38_meaning
195891: FROM xla_events_gt xet
195892: , CST_XLA_WIP_HEADERS_V h1
195893: , fnd_lookup_values fvl12
195894: , fnd_lookup_values fvl38
195895: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
195896: and xet.event_class_code = C_EVENT_CLASS_CODE
195897: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
195898: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 196772: , fnd_lookup_values fvl12

196768: ELSE null
196769: END source_meaning
196770: FROM xla_events_gt xet
196771: , CST_XLA_WIP_HEADERS_V h1
196772: , fnd_lookup_values fvl12
196773: , fnd_lookup_values fvl38
196774: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
196775: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196776: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 196773: , fnd_lookup_values fvl38

196769: END source_meaning
196770: FROM xla_events_gt xet
196771: , CST_XLA_WIP_HEADERS_V h1
196772: , fnd_lookup_values fvl12
196773: , fnd_lookup_values fvl38
196774: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
196775: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196776: AND xet.event_class_code = C_EVENT_CLASS_CODE
196777: AND h1.event_id = xet.event_id

Line 197034: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

197030: l_balance_type_code VARCHAR2(1) :=NULL;
197031: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
197032:
197033: --
197034: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
197035: --
197036:
197037: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197038: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 197104: , fnd_lookup_values fvl12

197100: , h1.TRANSFER_TO_GL_INDICATOR source_38
197101: , fvl38.meaning source_38_meaning
197102: FROM xla_events_gt xet
197103: , CST_XLA_WIP_HEADERS_V h1
197104: , fnd_lookup_values fvl12
197105: , fnd_lookup_values fvl38
197106: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
197107: and xet.event_class_code = C_EVENT_CLASS_CODE
197108: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 197105: , fnd_lookup_values fvl38

197101: , fvl38.meaning source_38_meaning
197102: FROM xla_events_gt xet
197103: , CST_XLA_WIP_HEADERS_V h1
197104: , fnd_lookup_values fvl12
197105: , fnd_lookup_values fvl38
197106: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
197107: and xet.event_class_code = C_EVENT_CLASS_CODE
197108: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
197109: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 197963: , fnd_lookup_values fvl12

197959: ELSE null
197960: END source_meaning
197961: FROM xla_events_gt xet
197962: , CST_XLA_INV_HEADERS_V h1
197963: , fnd_lookup_values fvl12
197964: , fnd_lookup_values fvl38
197965: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
197966: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
197967: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 197964: , fnd_lookup_values fvl38

197960: END source_meaning
197961: FROM xla_events_gt xet
197962: , CST_XLA_INV_HEADERS_V h1
197963: , fnd_lookup_values fvl12
197964: , fnd_lookup_values fvl38
197965: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
197966: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
197967: AND xet.event_class_code = C_EVENT_CLASS_CODE
197968: AND h1.event_id = xet.event_id

Line 198245: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

198241: l_balance_type_code VARCHAR2(1) :=NULL;
198242: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
198243:
198244: --
198245: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
198246: --
198247:
198248: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
198249: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 198311: , fnd_lookup_values fvl12

198307: , h1.TRANSFER_TO_GL_INDICATOR source_38
198308: , fvl38.meaning source_38_meaning
198309: FROM xla_events_gt xet
198310: , CST_XLA_INV_HEADERS_V h1
198311: , fnd_lookup_values fvl12
198312: , fnd_lookup_values fvl38
198313: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
198314: and xet.event_class_code = C_EVENT_CLASS_CODE
198315: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 198312: , fnd_lookup_values fvl38

198308: , fvl38.meaning source_38_meaning
198309: FROM xla_events_gt xet
198310: , CST_XLA_INV_HEADERS_V h1
198311: , fnd_lookup_values fvl12
198312: , fnd_lookup_values fvl38
198313: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
198314: and xet.event_class_code = C_EVENT_CLASS_CODE
198315: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
198316: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'