eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00707_AAD_S_000005_PKG dependencies on FND_LOOKUP_VALUES

Line 143220: , fnd_lookup_values fvl12

143216: ELSE null
143217: END source_meaning
143218: FROM xla_events_gt xet
143219: , CST_XLA_WIP_HEADERS_V h1
143220: , fnd_lookup_values fvl12
143221: , fnd_lookup_values fvl38
143222: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
143223: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143224: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 143221: , fnd_lookup_values fvl38

143217: END source_meaning
143218: FROM xla_events_gt xet
143219: , CST_XLA_WIP_HEADERS_V h1
143220: , fnd_lookup_values fvl12
143221: , fnd_lookup_values fvl38
143222: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
143223: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143224: AND xet.event_class_code = C_EVENT_CLASS_CODE
143225: AND h1.event_id = xet.event_id

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

143478: l_balance_type_code VARCHAR2(1) :=NULL;
143479: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
143480:
143481: --
143482: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
143483: --
143484:
143485: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143486: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 143552: , fnd_lookup_values fvl12

143548: , h1.TRANSFER_TO_GL_INDICATOR source_38
143549: , fvl38.meaning source_38_meaning
143550: FROM xla_events_gt xet
143551: , CST_XLA_WIP_HEADERS_V h1
143552: , fnd_lookup_values fvl12
143553: , fnd_lookup_values fvl38
143554: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
143555: and xet.event_class_code = C_EVENT_CLASS_CODE
143556: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 143553: , fnd_lookup_values fvl38

143549: , fvl38.meaning source_38_meaning
143550: FROM xla_events_gt xet
143551: , CST_XLA_WIP_HEADERS_V h1
143552: , fnd_lookup_values fvl12
143553: , fnd_lookup_values fvl38
143554: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
143555: and xet.event_class_code = C_EVENT_CLASS_CODE
143556: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
143557: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 144518: , fnd_lookup_values fvl12

144514: ELSE null
144515: END source_meaning
144516: FROM xla_events_gt xet
144517: , CST_XLA_AWO_HEADERS_V h1
144518: , fnd_lookup_values fvl12
144519: , fnd_lookup_values fvl38
144520: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
144521: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144522: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 144519: , fnd_lookup_values fvl38

144515: END source_meaning
144516: FROM xla_events_gt xet
144517: , CST_XLA_AWO_HEADERS_V h1
144518: , fnd_lookup_values fvl12
144519: , fnd_lookup_values fvl38
144520: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
144521: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
144522: AND xet.event_class_code = C_EVENT_CLASS_CODE
144523: AND h1.event_id = xet.event_id

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

144786: l_balance_type_code VARCHAR2(1) :=NULL;
144787: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
144788:
144789: --
144790: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
144791: --
144792:
144793: TYPE t_array_source_1 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ACCRUAL_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
144794: TYPE t_array_source_2 IS TABLE OF CST_XLA_AWO_HEADERS_V.WO_ERV_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;

Line 144864: , fnd_lookup_values fvl12

144860: , h1.TRANSFER_TO_GL_INDICATOR source_38
144861: , fvl38.meaning source_38_meaning
144862: FROM xla_events_gt xet
144863: , CST_XLA_AWO_HEADERS_V h1
144864: , fnd_lookup_values fvl12
144865: , fnd_lookup_values fvl38
144866: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144867: and xet.event_class_code = C_EVENT_CLASS_CODE
144868: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 144865: , fnd_lookup_values fvl38

144861: , fvl38.meaning source_38_meaning
144862: FROM xla_events_gt xet
144863: , CST_XLA_AWO_HEADERS_V h1
144864: , fnd_lookup_values fvl12
144865: , fnd_lookup_values fvl38
144866: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
144867: and xet.event_class_code = C_EVENT_CLASS_CODE
144868: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
144869: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 145785: , fnd_lookup_values fvl12

145781: ELSE null
145782: END source_meaning
145783: FROM xla_events_gt xet
145784: , CST_XLA_INV_HEADERS_V h1
145785: , fnd_lookup_values fvl12
145786: , fnd_lookup_values fvl38
145787: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
145788: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145789: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 145786: , fnd_lookup_values fvl38

145782: END source_meaning
145783: FROM xla_events_gt xet
145784: , CST_XLA_INV_HEADERS_V h1
145785: , fnd_lookup_values fvl12
145786: , fnd_lookup_values fvl38
145787: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
145788: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145789: AND xet.event_class_code = C_EVENT_CLASS_CODE
145790: AND h1.event_id = xet.event_id

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

146063: l_balance_type_code VARCHAR2(1) :=NULL;
146064: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
146065:
146066: --
146067: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
146068: --
146069:
146070: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146071: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 146133: , fnd_lookup_values fvl12

146129: , h1.TRANSFER_TO_GL_INDICATOR source_38
146130: , fvl38.meaning source_38_meaning
146131: FROM xla_events_gt xet
146132: , CST_XLA_INV_HEADERS_V h1
146133: , fnd_lookup_values fvl12
146134: , fnd_lookup_values fvl38
146135: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
146136: and xet.event_class_code = C_EVENT_CLASS_CODE
146137: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 146134: , fnd_lookup_values fvl38

146130: , fvl38.meaning source_38_meaning
146131: FROM xla_events_gt xet
146132: , CST_XLA_INV_HEADERS_V h1
146133: , fnd_lookup_values fvl12
146134: , fnd_lookup_values fvl38
146135: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
146136: and xet.event_class_code = C_EVENT_CLASS_CODE
146137: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
146138: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 147153: , fnd_lookup_values fvl12

147149: , CST_XLA_RCV_REF_V h3
147150: , PO_DISTS_REF_V h4
147151: , PO_HEADERS_REF_V h5
147152: , PSA_CST_XLA_UPG_V h6
147153: , fnd_lookup_values fvl12
147154: , fnd_lookup_values fvl38
147155: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
147156: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147157: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 147154: , fnd_lookup_values fvl38

147150: , PO_DISTS_REF_V h4
147151: , PO_HEADERS_REF_V h5
147152: , PSA_CST_XLA_UPG_V h6
147153: , fnd_lookup_values fvl12
147154: , fnd_lookup_values fvl38
147155: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
147156: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
147157: AND xet.event_class_code = C_EVENT_CLASS_CODE
147158: AND h1.event_id = xet.event_id

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

147411: l_balance_type_code VARCHAR2(1) :=NULL;
147412: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
147413:
147414: --
147415: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
147416: --
147417:
147418: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
147419: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 147519: , fnd_lookup_values fvl12

147515: , CST_XLA_RCV_REF_V h3
147516: , PO_DISTS_REF_V h4
147517: , PO_HEADERS_REF_V h5
147518: , PSA_CST_XLA_UPG_V h6
147519: , fnd_lookup_values fvl12
147520: , fnd_lookup_values fvl38
147521: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
147522: and xet.event_class_code = C_EVENT_CLASS_CODE
147523: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 147520: , fnd_lookup_values fvl38

147516: , PO_DISTS_REF_V h4
147517: , PO_HEADERS_REF_V h5
147518: , PSA_CST_XLA_UPG_V h6
147519: , fnd_lookup_values fvl12
147520: , fnd_lookup_values fvl38
147521: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
147522: and xet.event_class_code = C_EVENT_CLASS_CODE
147523: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
147524: 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 148474: , fnd_lookup_values fvl12

148470: , CST_XLA_INV_REF_V h3
148471: , PO_REQ_DISTS_REF_V h4
148472: , PO_REQ_HEADERS_REF_V h5
148473: , PSA_CST_XLA_UPG_V h6
148474: , fnd_lookup_values fvl12
148475: , fnd_lookup_values fvl38
148476: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
148477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148478: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 148475: , fnd_lookup_values fvl38

148471: , PO_REQ_DISTS_REF_V h4
148472: , PO_REQ_HEADERS_REF_V h5
148473: , PSA_CST_XLA_UPG_V h6
148474: , fnd_lookup_values fvl12
148475: , fnd_lookup_values fvl38
148476: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
148477: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148478: AND xet.event_class_code = C_EVENT_CLASS_CODE
148479: AND h1.event_id = xet.event_id

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

148752: l_balance_type_code VARCHAR2(1) :=NULL;
148753: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
148754:
148755: --
148756: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
148757: --
148758:
148759: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
148760: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 148856: , fnd_lookup_values fvl12

148852: , CST_XLA_INV_REF_V h3
148853: , PO_REQ_DISTS_REF_V h4
148854: , PO_REQ_HEADERS_REF_V h5
148855: , PSA_CST_XLA_UPG_V h6
148856: , fnd_lookup_values fvl12
148857: , fnd_lookup_values fvl38
148858: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148859: and xet.event_class_code = C_EVENT_CLASS_CODE
148860: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 148857: , fnd_lookup_values fvl38

148853: , PO_REQ_DISTS_REF_V h4
148854: , PO_REQ_HEADERS_REF_V h5
148855: , PSA_CST_XLA_UPG_V h6
148856: , fnd_lookup_values fvl12
148857: , fnd_lookup_values fvl38
148858: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
148859: and xet.event_class_code = C_EVENT_CLASS_CODE
148860: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
148861: 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 150030: , fnd_lookup_values fvl12

150026: ELSE null
150027: END source_meaning
150028: FROM xla_events_gt xet
150029: , CST_XLA_INV_HEADERS_V h1
150030: , fnd_lookup_values fvl12
150031: , fnd_lookup_values fvl38
150032: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
150033: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150034: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 150031: , fnd_lookup_values fvl38

150027: END source_meaning
150028: FROM xla_events_gt xet
150029: , CST_XLA_INV_HEADERS_V h1
150030: , fnd_lookup_values fvl12
150031: , fnd_lookup_values fvl38
150032: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
150033: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150034: AND xet.event_class_code = C_EVENT_CLASS_CODE
150035: AND h1.event_id = xet.event_id

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

150308: l_balance_type_code VARCHAR2(1) :=NULL;
150309: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
150310:
150311: --
150312: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
150313: --
150314:
150315: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150316: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 150378: , fnd_lookup_values fvl12

150374: , h1.TRANSFER_TO_GL_INDICATOR source_38
150375: , fvl38.meaning source_38_meaning
150376: FROM xla_events_gt xet
150377: , CST_XLA_INV_HEADERS_V h1
150378: , fnd_lookup_values fvl12
150379: , fnd_lookup_values fvl38
150380: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
150381: and xet.event_class_code = C_EVENT_CLASS_CODE
150382: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 150379: , fnd_lookup_values fvl38

150375: , fvl38.meaning source_38_meaning
150376: FROM xla_events_gt xet
150377: , CST_XLA_INV_HEADERS_V h1
150378: , fnd_lookup_values fvl12
150379: , fnd_lookup_values fvl38
150380: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
150381: and xet.event_class_code = C_EVENT_CLASS_CODE
150382: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
150383: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 151494: , fnd_lookup_values fvl12

151490: , CST_XLA_INV_REF_V h3
151491: , PO_REQ_DISTS_REF_V h4
151492: , PO_REQ_HEADERS_REF_V h5
151493: , PSA_CST_XLA_UPG_V h6
151494: , fnd_lookup_values fvl12
151495: , fnd_lookup_values fvl38
151496: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
151497: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151498: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 151495: , fnd_lookup_values fvl38

151491: , PO_REQ_DISTS_REF_V h4
151492: , PO_REQ_HEADERS_REF_V h5
151493: , PSA_CST_XLA_UPG_V h6
151494: , fnd_lookup_values fvl12
151495: , fnd_lookup_values fvl38
151496: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
151497: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
151498: AND xet.event_class_code = C_EVENT_CLASS_CODE
151499: AND h1.event_id = xet.event_id

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

151772: l_balance_type_code VARCHAR2(1) :=NULL;
151773: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
151774:
151775: --
151776: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
151777: --
151778:
151779: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
151780: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 151876: , fnd_lookup_values fvl12

151872: , CST_XLA_INV_REF_V h3
151873: , PO_REQ_DISTS_REF_V h4
151874: , PO_REQ_HEADERS_REF_V h5
151875: , PSA_CST_XLA_UPG_V h6
151876: , fnd_lookup_values fvl12
151877: , fnd_lookup_values fvl38
151878: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151879: and xet.event_class_code = C_EVENT_CLASS_CODE
151880: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 151877: , fnd_lookup_values fvl38

151873: , PO_REQ_DISTS_REF_V h4
151874: , PO_REQ_HEADERS_REF_V h5
151875: , PSA_CST_XLA_UPG_V h6
151876: , fnd_lookup_values fvl12
151877: , fnd_lookup_values fvl38
151878: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
151879: and xet.event_class_code = C_EVENT_CLASS_CODE
151880: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
151881: 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 153011: , fnd_lookup_values fvl12

153007: ELSE null
153008: END source_meaning
153009: FROM xla_events_gt xet
153010: , CST_XLA_INV_HEADERS_V h1
153011: , fnd_lookup_values fvl12
153012: , fnd_lookup_values fvl38
153013: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
153014: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153015: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 153012: , fnd_lookup_values fvl38

153008: END source_meaning
153009: FROM xla_events_gt xet
153010: , CST_XLA_INV_HEADERS_V h1
153011: , fnd_lookup_values fvl12
153012: , fnd_lookup_values fvl38
153013: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
153014: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153015: AND xet.event_class_code = C_EVENT_CLASS_CODE
153016: AND h1.event_id = xet.event_id

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

153289: l_balance_type_code VARCHAR2(1) :=NULL;
153290: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
153291:
153292: --
153293: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
153294: --
153295:
153296: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
153297: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 153359: , fnd_lookup_values fvl12

153355: , h1.TRANSFER_TO_GL_INDICATOR source_38
153356: , fvl38.meaning source_38_meaning
153357: FROM xla_events_gt xet
153358: , CST_XLA_INV_HEADERS_V h1
153359: , fnd_lookup_values fvl12
153360: , fnd_lookup_values fvl38
153361: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153362: and xet.event_class_code = C_EVENT_CLASS_CODE
153363: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 153360: , fnd_lookup_values fvl38

153356: , fvl38.meaning source_38_meaning
153357: FROM xla_events_gt xet
153358: , CST_XLA_INV_HEADERS_V h1
153359: , fnd_lookup_values fvl12
153360: , fnd_lookup_values fvl38
153361: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
153362: and xet.event_class_code = C_EVENT_CLASS_CODE
153363: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
153364: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 154363: , fnd_lookup_values fvl12

154359: ELSE null
154360: END source_meaning
154361: FROM xla_events_gt xet
154362: , CST_XLA_INV_HEADERS_V h1
154363: , fnd_lookup_values fvl12
154364: , fnd_lookup_values fvl38
154365: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
154366: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154367: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 154364: , fnd_lookup_values fvl38

154360: END source_meaning
154361: FROM xla_events_gt xet
154362: , CST_XLA_INV_HEADERS_V h1
154363: , fnd_lookup_values fvl12
154364: , fnd_lookup_values fvl38
154365: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
154366: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154367: AND xet.event_class_code = C_EVENT_CLASS_CODE
154368: AND h1.event_id = xet.event_id

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

154641: l_balance_type_code VARCHAR2(1) :=NULL;
154642: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
154643:
154644: --
154645: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
154646: --
154647:
154648: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
154649: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 154711: , fnd_lookup_values fvl12

154707: , h1.TRANSFER_TO_GL_INDICATOR source_38
154708: , fvl38.meaning source_38_meaning
154709: FROM xla_events_gt xet
154710: , CST_XLA_INV_HEADERS_V h1
154711: , fnd_lookup_values fvl12
154712: , fnd_lookup_values fvl38
154713: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
154714: and xet.event_class_code = C_EVENT_CLASS_CODE
154715: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 154712: , fnd_lookup_values fvl38

154708: , fvl38.meaning source_38_meaning
154709: FROM xla_events_gt xet
154710: , CST_XLA_INV_HEADERS_V h1
154711: , fnd_lookup_values fvl12
154712: , fnd_lookup_values fvl38
154713: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
154714: and xet.event_class_code = C_EVENT_CLASS_CODE
154715: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
154716: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 155653: , fnd_lookup_values fvl12

155649: , CST_XLA_INV_REF_V h3
155650: , PO_REQ_DISTS_REF_V h4
155651: , PO_REQ_HEADERS_REF_V h5
155652: , PSA_CST_XLA_UPG_V h6
155653: , fnd_lookup_values fvl12
155654: , fnd_lookup_values fvl38
155655: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
155656: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155657: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 155654: , fnd_lookup_values fvl38

155650: , PO_REQ_DISTS_REF_V h4
155651: , PO_REQ_HEADERS_REF_V h5
155652: , PSA_CST_XLA_UPG_V h6
155653: , fnd_lookup_values fvl12
155654: , fnd_lookup_values fvl38
155655: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
155656: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
155657: AND xet.event_class_code = C_EVENT_CLASS_CODE
155658: AND h1.event_id = xet.event_id

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

155931: l_balance_type_code VARCHAR2(1) :=NULL;
155932: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
155933:
155934: --
155935: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
155936: --
155937:
155938: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
155939: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 156035: , fnd_lookup_values fvl12

156031: , CST_XLA_INV_REF_V h3
156032: , PO_REQ_DISTS_REF_V h4
156033: , PO_REQ_HEADERS_REF_V h5
156034: , PSA_CST_XLA_UPG_V h6
156035: , fnd_lookup_values fvl12
156036: , fnd_lookup_values fvl38
156037: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156038: and xet.event_class_code = C_EVENT_CLASS_CODE
156039: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 156036: , fnd_lookup_values fvl38

156032: , PO_REQ_DISTS_REF_V h4
156033: , PO_REQ_HEADERS_REF_V h5
156034: , PSA_CST_XLA_UPG_V h6
156035: , fnd_lookup_values fvl12
156036: , fnd_lookup_values fvl38
156037: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
156038: and xet.event_class_code = C_EVENT_CLASS_CODE
156039: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
156040: 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 156975: , fnd_lookup_values fvl12

156971: ELSE null
156972: END source_meaning
156973: FROM xla_events_gt xet
156974: , CST_XLA_INV_HEADERS_V h1
156975: , fnd_lookup_values fvl12
156976: , fnd_lookup_values fvl38
156977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
156978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156979: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 156976: , fnd_lookup_values fvl38

156972: END source_meaning
156973: FROM xla_events_gt xet
156974: , CST_XLA_INV_HEADERS_V h1
156975: , fnd_lookup_values fvl12
156976: , fnd_lookup_values fvl38
156977: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
156978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156979: AND xet.event_class_code = C_EVENT_CLASS_CODE
156980: AND h1.event_id = xet.event_id

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

157253: l_balance_type_code VARCHAR2(1) :=NULL;
157254: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
157255:
157256: --
157257: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
157258: --
157259:
157260: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
157261: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 157323: , fnd_lookup_values fvl12

157319: , h1.TRANSFER_TO_GL_INDICATOR source_38
157320: , fvl38.meaning source_38_meaning
157321: FROM xla_events_gt xet
157322: , CST_XLA_INV_HEADERS_V h1
157323: , fnd_lookup_values fvl12
157324: , fnd_lookup_values fvl38
157325: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157326: and xet.event_class_code = C_EVENT_CLASS_CODE
157327: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 157324: , fnd_lookup_values fvl38

157320: , fvl38.meaning source_38_meaning
157321: FROM xla_events_gt xet
157322: , CST_XLA_INV_HEADERS_V h1
157323: , fnd_lookup_values fvl12
157324: , fnd_lookup_values fvl38
157325: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
157326: and xet.event_class_code = C_EVENT_CLASS_CODE
157327: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
157328: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 158385: , fnd_lookup_values fvl12

158381: ELSE null
158382: END source_meaning
158383: FROM xla_events_gt xet
158384: , CST_XLA_INV_HEADERS_V h1
158385: , fnd_lookup_values fvl12
158386: , fnd_lookup_values fvl38
158387: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
158388: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158389: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 158386: , fnd_lookup_values fvl38

158382: END source_meaning
158383: FROM xla_events_gt xet
158384: , CST_XLA_INV_HEADERS_V h1
158385: , fnd_lookup_values fvl12
158386: , fnd_lookup_values fvl38
158387: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
158388: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158389: AND xet.event_class_code = C_EVENT_CLASS_CODE
158390: AND h1.event_id = xet.event_id

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

158663: l_balance_type_code VARCHAR2(1) :=NULL;
158664: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
158665:
158666: --
158667: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
158668: --
158669:
158670: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
158671: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 158733: , fnd_lookup_values fvl12

158729: , h1.TRANSFER_TO_GL_INDICATOR source_38
158730: , fvl38.meaning source_38_meaning
158731: FROM xla_events_gt xet
158732: , CST_XLA_INV_HEADERS_V h1
158733: , fnd_lookup_values fvl12
158734: , fnd_lookup_values fvl38
158735: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
158736: and xet.event_class_code = C_EVENT_CLASS_CODE
158737: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 158734: , fnd_lookup_values fvl38

158730: , fvl38.meaning source_38_meaning
158731: FROM xla_events_gt xet
158732: , CST_XLA_INV_HEADERS_V h1
158733: , fnd_lookup_values fvl12
158734: , fnd_lookup_values fvl38
158735: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
158736: and xet.event_class_code = C_EVENT_CLASS_CODE
158737: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
158738: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 159708: , fnd_lookup_values fvl12

159704: ELSE null
159705: END source_meaning
159706: FROM xla_events_gt xet
159707: , CST_XLA_INV_HEADERS_V h1
159708: , fnd_lookup_values fvl12
159709: , fnd_lookup_values fvl38
159710: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
159711: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159712: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 159709: , fnd_lookup_values fvl38

159705: END source_meaning
159706: FROM xla_events_gt xet
159707: , CST_XLA_INV_HEADERS_V h1
159708: , fnd_lookup_values fvl12
159709: , fnd_lookup_values fvl38
159710: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
159711: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159712: AND xet.event_class_code = C_EVENT_CLASS_CODE
159713: AND h1.event_id = xet.event_id

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

159986: l_balance_type_code VARCHAR2(1) :=NULL;
159987: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
159988:
159989: --
159990: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
159991: --
159992:
159993: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
159994: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 160056: , fnd_lookup_values fvl12

160052: , h1.TRANSFER_TO_GL_INDICATOR source_38
160053: , fvl38.meaning source_38_meaning
160054: FROM xla_events_gt xet
160055: , CST_XLA_INV_HEADERS_V h1
160056: , fnd_lookup_values fvl12
160057: , fnd_lookup_values fvl38
160058: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160059: and xet.event_class_code = C_EVENT_CLASS_CODE
160060: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 160057: , fnd_lookup_values fvl38

160053: , fvl38.meaning source_38_meaning
160054: FROM xla_events_gt xet
160055: , CST_XLA_INV_HEADERS_V h1
160056: , fnd_lookup_values fvl12
160057: , fnd_lookup_values fvl38
160058: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
160059: and xet.event_class_code = C_EVENT_CLASS_CODE
160060: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
160061: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 160944: , fnd_lookup_values fvl12

160940: ELSE null
160941: END source_meaning
160942: FROM xla_events_gt xet
160943: , CST_XLA_INV_HEADERS_V h1
160944: , fnd_lookup_values fvl12
160945: , fnd_lookup_values fvl38
160946: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
160947: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
160948: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 160945: , fnd_lookup_values fvl38

160941: END source_meaning
160942: FROM xla_events_gt xet
160943: , CST_XLA_INV_HEADERS_V h1
160944: , fnd_lookup_values fvl12
160945: , fnd_lookup_values fvl38
160946: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
160947: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
160948: AND xet.event_class_code = C_EVENT_CLASS_CODE
160949: AND h1.event_id = xet.event_id

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

161222: l_balance_type_code VARCHAR2(1) :=NULL;
161223: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
161224:
161225: --
161226: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
161227: --
161228:
161229: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
161230: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 161292: , fnd_lookup_values fvl12

161288: , h1.TRANSFER_TO_GL_INDICATOR source_38
161289: , fvl38.meaning source_38_meaning
161290: FROM xla_events_gt xet
161291: , CST_XLA_INV_HEADERS_V h1
161292: , fnd_lookup_values fvl12
161293: , fnd_lookup_values fvl38
161294: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161295: and xet.event_class_code = C_EVENT_CLASS_CODE
161296: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 161293: , fnd_lookup_values fvl38

161289: , fvl38.meaning source_38_meaning
161290: FROM xla_events_gt xet
161291: , CST_XLA_INV_HEADERS_V h1
161292: , fnd_lookup_values fvl12
161293: , fnd_lookup_values fvl38
161294: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
161295: and xet.event_class_code = C_EVENT_CLASS_CODE
161296: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
161297: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 162255: , fnd_lookup_values fvl12

162251: FROM xla_events_gt xet
162252: , CST_XLA_RCV_HEADERS_V h1
162253: , CST_XLA_RCV_REF_V h3
162254: , PO_DISTS_REF_V h4
162255: , fnd_lookup_values fvl12
162256: , fnd_lookup_values fvl38
162257: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162258: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162259: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 162256: , fnd_lookup_values fvl38

162252: , CST_XLA_RCV_HEADERS_V h1
162253: , CST_XLA_RCV_REF_V h3
162254: , PO_DISTS_REF_V h4
162255: , fnd_lookup_values fvl12
162256: , fnd_lookup_values fvl38
162257: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162258: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162259: AND xet.event_class_code = C_EVENT_CLASS_CODE
162260: AND h1.event_id = xet.event_id

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

162513: l_balance_type_code VARCHAR2(1) :=NULL;
162514: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
162515:
162516: --
162517: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
162518: --
162519:
162520: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
162521: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 162586: , fnd_lookup_values fvl12

162582: FROM xla_events_gt xet
162583: , CST_XLA_RCV_HEADERS_V h1
162584: , CST_XLA_RCV_REF_V h3
162585: , PO_DISTS_REF_V h4
162586: , fnd_lookup_values fvl12
162587: , fnd_lookup_values fvl38
162588: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162589: and xet.event_class_code = C_EVENT_CLASS_CODE
162590: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 162587: , fnd_lookup_values fvl38

162583: , CST_XLA_RCV_HEADERS_V h1
162584: , CST_XLA_RCV_REF_V h3
162585: , PO_DISTS_REF_V h4
162586: , fnd_lookup_values fvl12
162587: , fnd_lookup_values fvl38
162588: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
162589: and xet.event_class_code = C_EVENT_CLASS_CODE
162590: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
162591: 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 163519: , fnd_lookup_values fvl12

163515: FROM xla_events_gt xet
163516: , CST_XLA_RCV_HEADERS_V h1
163517: , CST_XLA_RCV_REF_V h3
163518: , PO_DISTS_REF_V h4
163519: , fnd_lookup_values fvl12
163520: , fnd_lookup_values fvl38
163521: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
163522: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163523: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 163520: , fnd_lookup_values fvl38

163516: , CST_XLA_RCV_HEADERS_V h1
163517: , CST_XLA_RCV_REF_V h3
163518: , PO_DISTS_REF_V h4
163519: , fnd_lookup_values fvl12
163520: , fnd_lookup_values fvl38
163521: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
163522: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163523: AND xet.event_class_code = C_EVENT_CLASS_CODE
163524: AND h1.event_id = xet.event_id

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

163777: l_balance_type_code VARCHAR2(1) :=NULL;
163778: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
163779:
163780: --
163781: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
163782: --
163783:
163784: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
163785: TYPE t_array_source_32 IS TABLE OF PO_DISTS_REF_V.ENTERED_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 163853: , fnd_lookup_values fvl12

163849: FROM xla_events_gt xet
163850: , CST_XLA_RCV_HEADERS_V h1
163851: , CST_XLA_RCV_REF_V h3
163852: , PO_DISTS_REF_V h4
163853: , fnd_lookup_values fvl12
163854: , fnd_lookup_values fvl38
163855: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
163856: and xet.event_class_code = C_EVENT_CLASS_CODE
163857: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 163854: , fnd_lookup_values fvl38

163850: , CST_XLA_RCV_HEADERS_V h1
163851: , CST_XLA_RCV_REF_V h3
163852: , PO_DISTS_REF_V h4
163853: , fnd_lookup_values fvl12
163854: , fnd_lookup_values fvl38
163855: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
163856: and xet.event_class_code = C_EVENT_CLASS_CODE
163857: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
163858: 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 164718: , fnd_lookup_values fvl12

164714: ELSE null
164715: END source_meaning
164716: FROM xla_events_gt xet
164717: , CST_XLA_INV_HEADERS_V h1
164718: , fnd_lookup_values fvl12
164719: , fnd_lookup_values fvl35
164720: , fnd_lookup_values fvl38
164721: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
164722: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 164719: , fnd_lookup_values fvl35

164715: END source_meaning
164716: FROM xla_events_gt xet
164717: , CST_XLA_INV_HEADERS_V h1
164718: , fnd_lookup_values fvl12
164719: , fnd_lookup_values fvl35
164720: , fnd_lookup_values fvl38
164721: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
164722: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
164723: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 164720: , fnd_lookup_values fvl38

164716: FROM xla_events_gt xet
164717: , CST_XLA_INV_HEADERS_V h1
164718: , fnd_lookup_values fvl12
164719: , fnd_lookup_values fvl35
164720: , fnd_lookup_values fvl38
164721: ,(select rownum r from all_objects where rownum <= 3 and owner = p_apps_owner)
164722: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
164723: AND xet.event_class_code = C_EVENT_CLASS_CODE
164724: AND h1.event_id = xet.event_id

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

165001: l_balance_type_code VARCHAR2(1) :=NULL;
165002: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
165003:
165004: --
165005: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165006: --
165007:
165008: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165009: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ACTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 165076: , fnd_lookup_values fvl12

165072: , h1.TRANSFER_TO_GL_INDICATOR source_38
165073: , fvl38.meaning source_38_meaning
165074: FROM xla_events_gt xet
165075: , CST_XLA_INV_HEADERS_V h1
165076: , fnd_lookup_values fvl12
165077: , fnd_lookup_values fvl35
165078: , fnd_lookup_values fvl38
165079: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165080: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 165077: , fnd_lookup_values fvl35

165073: , fvl38.meaning source_38_meaning
165074: FROM xla_events_gt xet
165075: , CST_XLA_INV_HEADERS_V h1
165076: , fnd_lookup_values fvl12
165077: , fnd_lookup_values fvl35
165078: , fnd_lookup_values fvl38
165079: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165080: and xet.event_class_code = C_EVENT_CLASS_CODE
165081: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 165078: , fnd_lookup_values fvl38

165074: FROM xla_events_gt xet
165075: , CST_XLA_INV_HEADERS_V h1
165076: , fnd_lookup_values fvl12
165077: , fnd_lookup_values fvl35
165078: , fnd_lookup_values fvl38
165079: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
165080: and xet.event_class_code = C_EVENT_CLASS_CODE
165081: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
165082: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 166035: , fnd_lookup_values fvl12

166031: ELSE null
166032: END source_meaning
166033: FROM xla_events_gt xet
166034: , CST_XLA_INV_HEADERS_V h1
166035: , fnd_lookup_values fvl12
166036: , fnd_lookup_values fvl38
166037: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
166038: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166039: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 166036: , fnd_lookup_values fvl38

166032: END source_meaning
166033: FROM xla_events_gt xet
166034: , CST_XLA_INV_HEADERS_V h1
166035: , fnd_lookup_values fvl12
166036: , fnd_lookup_values fvl38
166037: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
166038: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166039: AND xet.event_class_code = C_EVENT_CLASS_CODE
166040: AND h1.event_id = xet.event_id

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

166313: l_balance_type_code VARCHAR2(1) :=NULL;
166314: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
166315:
166316: --
166317: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
166318: --
166319:
166320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
166321: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 166383: , fnd_lookup_values fvl12

166379: , h1.TRANSFER_TO_GL_INDICATOR source_38
166380: , fvl38.meaning source_38_meaning
166381: FROM xla_events_gt xet
166382: , CST_XLA_INV_HEADERS_V h1
166383: , fnd_lookup_values fvl12
166384: , fnd_lookup_values fvl38
166385: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166386: and xet.event_class_code = C_EVENT_CLASS_CODE
166387: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 166384: , fnd_lookup_values fvl38

166380: , fvl38.meaning source_38_meaning
166381: FROM xla_events_gt xet
166382: , CST_XLA_INV_HEADERS_V h1
166383: , fnd_lookup_values fvl12
166384: , fnd_lookup_values fvl38
166385: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
166386: and xet.event_class_code = C_EVENT_CLASS_CODE
166387: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
166388: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 167242: , fnd_lookup_values fvl12

167238: ELSE null
167239: END source_meaning
167240: FROM xla_events_gt xet
167241: , CST_XLA_INV_HEADERS_V h1
167242: , fnd_lookup_values fvl12
167243: , fnd_lookup_values fvl38
167244: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
167245: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167246: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 167243: , fnd_lookup_values fvl38

167239: END source_meaning
167240: FROM xla_events_gt xet
167241: , CST_XLA_INV_HEADERS_V h1
167242: , fnd_lookup_values fvl12
167243: , fnd_lookup_values fvl38
167244: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
167245: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
167246: AND xet.event_class_code = C_EVENT_CLASS_CODE
167247: AND h1.event_id = xet.event_id

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

167520: l_balance_type_code VARCHAR2(1) :=NULL;
167521: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
167522:
167523: --
167524: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
167525: --
167526:
167527: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
167528: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 167590: , fnd_lookup_values fvl12

167586: , h1.TRANSFER_TO_GL_INDICATOR source_38
167587: , fvl38.meaning source_38_meaning
167588: FROM xla_events_gt xet
167589: , CST_XLA_INV_HEADERS_V h1
167590: , fnd_lookup_values fvl12
167591: , fnd_lookup_values fvl38
167592: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
167593: and xet.event_class_code = C_EVENT_CLASS_CODE
167594: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 167591: , fnd_lookup_values fvl38

167587: , fvl38.meaning source_38_meaning
167588: FROM xla_events_gt xet
167589: , CST_XLA_INV_HEADERS_V h1
167590: , fnd_lookup_values fvl12
167591: , fnd_lookup_values fvl38
167592: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
167593: and xet.event_class_code = C_EVENT_CLASS_CODE
167594: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
167595: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 168478: , fnd_lookup_values fvl12

168474: ELSE null
168475: END source_meaning
168476: FROM xla_events_gt xet
168477: , CST_XLA_INV_HEADERS_V h1
168478: , fnd_lookup_values fvl12
168479: , fnd_lookup_values fvl38
168480: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
168481: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168482: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 168479: , fnd_lookup_values fvl38

168475: END source_meaning
168476: FROM xla_events_gt xet
168477: , CST_XLA_INV_HEADERS_V h1
168478: , fnd_lookup_values fvl12
168479: , fnd_lookup_values fvl38
168480: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
168481: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168482: AND xet.event_class_code = C_EVENT_CLASS_CODE
168483: AND h1.event_id = xet.event_id

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

168756: l_balance_type_code VARCHAR2(1) :=NULL;
168757: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
168758:
168759: --
168760: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
168761: --
168762:
168763: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
168764: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 168826: , fnd_lookup_values fvl12

168822: , h1.TRANSFER_TO_GL_INDICATOR source_38
168823: , fvl38.meaning source_38_meaning
168824: FROM xla_events_gt xet
168825: , CST_XLA_INV_HEADERS_V h1
168826: , fnd_lookup_values fvl12
168827: , fnd_lookup_values fvl38
168828: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168829: and xet.event_class_code = C_EVENT_CLASS_CODE
168830: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 168827: , fnd_lookup_values fvl38

168823: , fvl38.meaning source_38_meaning
168824: FROM xla_events_gt xet
168825: , CST_XLA_INV_HEADERS_V h1
168826: , fnd_lookup_values fvl12
168827: , fnd_lookup_values fvl38
168828: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
168829: and xet.event_class_code = C_EVENT_CLASS_CODE
168830: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
168831: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 169787: , fnd_lookup_values fvl12

169783: ELSE null
169784: END source_meaning
169785: FROM xla_events_gt xet
169786: , CST_XLA_WIP_HEADERS_V h1
169787: , fnd_lookup_values fvl12
169788: , fnd_lookup_values fvl38
169789: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169790: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169791: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 169788: , fnd_lookup_values fvl38

169784: END source_meaning
169785: FROM xla_events_gt xet
169786: , CST_XLA_WIP_HEADERS_V h1
169787: , fnd_lookup_values fvl12
169788: , fnd_lookup_values fvl38
169789: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169790: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169791: AND xet.event_class_code = C_EVENT_CLASS_CODE
169792: AND h1.event_id = xet.event_id

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

170045: l_balance_type_code VARCHAR2(1) :=NULL;
170046: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
170047:
170048: --
170049: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
170050: --
170051:
170052: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
170053: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 170116: , fnd_lookup_values fvl12

170112: , h1.TRANSFER_TO_GL_INDICATOR source_38
170113: , fvl38.meaning source_38_meaning
170114: FROM xla_events_gt xet
170115: , CST_XLA_WIP_HEADERS_V h1
170116: , fnd_lookup_values fvl12
170117: , fnd_lookup_values fvl38
170118: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
170119: and xet.event_class_code = C_EVENT_CLASS_CODE
170120: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 170117: , fnd_lookup_values fvl38

170113: , fvl38.meaning source_38_meaning
170114: FROM xla_events_gt xet
170115: , CST_XLA_WIP_HEADERS_V h1
170116: , fnd_lookup_values fvl12
170117: , fnd_lookup_values fvl38
170118: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
170119: and xet.event_class_code = C_EVENT_CLASS_CODE
170120: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
170121: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 171157: , fnd_lookup_values fvl12

171153: , CST_XLA_RCV_REF_V h3
171154: , PO_DISTS_REF_V h4
171155: , PO_HEADERS_REF_V h5
171156: , PSA_CST_XLA_PEA_UPG_V h6
171157: , fnd_lookup_values fvl12
171158: , fnd_lookup_values fvl38
171159: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
171160: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171161: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 171158: , fnd_lookup_values fvl38

171154: , PO_DISTS_REF_V h4
171155: , PO_HEADERS_REF_V h5
171156: , PSA_CST_XLA_PEA_UPG_V h6
171157: , fnd_lookup_values fvl12
171158: , fnd_lookup_values fvl38
171159: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
171160: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171161: AND xet.event_class_code = C_EVENT_CLASS_CODE
171162: AND h1.event_id = xet.event_id

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

171415: l_balance_type_code VARCHAR2(1) :=NULL;
171416: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
171417:
171418: --
171419: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
171420: --
171421:
171422: TYPE t_array_source_6 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
171423: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 171523: , fnd_lookup_values fvl12

171519: , CST_XLA_RCV_REF_V h3
171520: , PO_DISTS_REF_V h4
171521: , PO_HEADERS_REF_V h5
171522: , PSA_CST_XLA_PEA_UPG_V h6
171523: , fnd_lookup_values fvl12
171524: , fnd_lookup_values fvl38
171525: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
171526: and xet.event_class_code = C_EVENT_CLASS_CODE
171527: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 171524: , fnd_lookup_values fvl38

171520: , PO_DISTS_REF_V h4
171521: , PO_HEADERS_REF_V h5
171522: , PSA_CST_XLA_PEA_UPG_V h6
171523: , fnd_lookup_values fvl12
171524: , fnd_lookup_values fvl38
171525: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
171526: and xet.event_class_code = C_EVENT_CLASS_CODE
171527: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
171528: 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 172524: , fnd_lookup_values fvl12

172520: , CST_XLA_INV_REF_V h3
172521: , PO_DISTS_REF_V h4
172522: , PO_HEADERS_REF_V h5
172523: , PSA_CST_XLA_UPG_V h6
172524: , fnd_lookup_values fvl12
172525: , fnd_lookup_values fvl38
172526: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
172527: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172528: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 172525: , fnd_lookup_values fvl38

172521: , PO_DISTS_REF_V h4
172522: , PO_HEADERS_REF_V h5
172523: , PSA_CST_XLA_UPG_V h6
172524: , fnd_lookup_values fvl12
172525: , fnd_lookup_values fvl38
172526: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
172527: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
172528: AND xet.event_class_code = C_EVENT_CLASS_CODE
172529: AND h1.event_id = xet.event_id

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

172802: l_balance_type_code VARCHAR2(1) :=NULL;
172803: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
172804:
172805: --
172806: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
172807: --
172808:
172809: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
172810: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 172906: , fnd_lookup_values fvl12

172902: , CST_XLA_INV_REF_V h3
172903: , PO_DISTS_REF_V h4
172904: , PO_HEADERS_REF_V h5
172905: , PSA_CST_XLA_UPG_V h6
172906: , fnd_lookup_values fvl12
172907: , fnd_lookup_values fvl38
172908: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
172909: and xet.event_class_code = C_EVENT_CLASS_CODE
172910: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 172907: , fnd_lookup_values fvl38

172903: , PO_DISTS_REF_V h4
172904: , PO_HEADERS_REF_V h5
172905: , PSA_CST_XLA_UPG_V h6
172906: , fnd_lookup_values fvl12
172907: , fnd_lookup_values fvl38
172908: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
172909: and xet.event_class_code = C_EVENT_CLASS_CODE
172910: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
172911: 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 174061: , fnd_lookup_values fvl12

174057: ELSE null
174058: END source_meaning
174059: FROM xla_events_gt xet
174060: , CST_XLA_RCV_HEADERS_V h1
174061: , fnd_lookup_values fvl12
174062: , fnd_lookup_values fvl38
174063: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
174064: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174065: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 174062: , fnd_lookup_values fvl38

174058: END source_meaning
174059: FROM xla_events_gt xet
174060: , CST_XLA_RCV_HEADERS_V h1
174061: , fnd_lookup_values fvl12
174062: , fnd_lookup_values fvl38
174063: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
174064: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174065: AND xet.event_class_code = C_EVENT_CLASS_CODE
174066: AND h1.event_id = xet.event_id

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

174319: l_balance_type_code VARCHAR2(1) :=NULL;
174320: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
174321:
174322: --
174323: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
174324: --
174325:
174326: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
174327: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 174393: , fnd_lookup_values fvl12

174389: , h1.TRANSFER_TO_GL_INDICATOR source_38
174390: , fvl38.meaning source_38_meaning
174391: FROM xla_events_gt xet
174392: , CST_XLA_RCV_HEADERS_V h1
174393: , fnd_lookup_values fvl12
174394: , fnd_lookup_values fvl38
174395: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
174396: and xet.event_class_code = C_EVENT_CLASS_CODE
174397: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 174394: , fnd_lookup_values fvl38

174390: , fvl38.meaning source_38_meaning
174391: FROM xla_events_gt xet
174392: , CST_XLA_RCV_HEADERS_V h1
174393: , fnd_lookup_values fvl12
174394: , fnd_lookup_values fvl38
174395: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
174396: and xet.event_class_code = C_EVENT_CLASS_CODE
174397: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
174398: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 175368: , fnd_lookup_values fvl12

175364: ELSE null
175365: END source_meaning
175366: FROM xla_events_gt xet
175367: , CST_XLA_INV_HEADERS_V h1
175368: , fnd_lookup_values fvl12
175369: , fnd_lookup_values fvl38
175370: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
175371: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175372: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 175369: , fnd_lookup_values fvl38

175365: END source_meaning
175366: FROM xla_events_gt xet
175367: , CST_XLA_INV_HEADERS_V h1
175368: , fnd_lookup_values fvl12
175369: , fnd_lookup_values fvl38
175370: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
175371: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175372: AND xet.event_class_code = C_EVENT_CLASS_CODE
175373: AND h1.event_id = xet.event_id

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

175646: l_balance_type_code VARCHAR2(1) :=NULL;
175647: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
175648:
175649: --
175650: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
175651: --
175652:
175653: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
175654: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 175716: , fnd_lookup_values fvl12

175712: , h1.TRANSFER_TO_GL_INDICATOR source_38
175713: , fvl38.meaning source_38_meaning
175714: FROM xla_events_gt xet
175715: , CST_XLA_INV_HEADERS_V h1
175716: , fnd_lookup_values fvl12
175717: , fnd_lookup_values fvl38
175718: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175719: and xet.event_class_code = C_EVENT_CLASS_CODE
175720: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 175717: , fnd_lookup_values fvl38

175713: , fvl38.meaning source_38_meaning
175714: FROM xla_events_gt xet
175715: , CST_XLA_INV_HEADERS_V h1
175716: , fnd_lookup_values fvl12
175717: , fnd_lookup_values fvl38
175718: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
175719: and xet.event_class_code = C_EVENT_CLASS_CODE
175720: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
175721: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 176590: , fnd_lookup_values fvl12

176586: ELSE null
176587: END source_meaning
176588: FROM xla_events_gt xet
176589: , CST_XLA_RCV_HEADERS_V h1
176590: , fnd_lookup_values fvl12
176591: , fnd_lookup_values fvl38
176592: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
176593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
176594: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 176591: , fnd_lookup_values fvl38

176587: END source_meaning
176588: FROM xla_events_gt xet
176589: , CST_XLA_RCV_HEADERS_V h1
176590: , fnd_lookup_values fvl12
176591: , fnd_lookup_values fvl38
176592: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
176593: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
176594: AND xet.event_class_code = C_EVENT_CLASS_CODE
176595: AND h1.event_id = xet.event_id

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

176848: l_balance_type_code VARCHAR2(1) :=NULL;
176849: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
176850:
176851: --
176852: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
176853: --
176854:
176855: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
176856: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 176919: , fnd_lookup_values fvl12

176915: , h1.TRANSFER_TO_GL_INDICATOR source_38
176916: , fvl38.meaning source_38_meaning
176917: FROM xla_events_gt xet
176918: , CST_XLA_RCV_HEADERS_V h1
176919: , fnd_lookup_values fvl12
176920: , fnd_lookup_values fvl38
176921: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
176922: and xet.event_class_code = C_EVENT_CLASS_CODE
176923: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 176920: , fnd_lookup_values fvl38

176916: , fvl38.meaning source_38_meaning
176917: FROM xla_events_gt xet
176918: , CST_XLA_RCV_HEADERS_V h1
176919: , fnd_lookup_values fvl12
176920: , fnd_lookup_values fvl38
176921: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
176922: and xet.event_class_code = C_EVENT_CLASS_CODE
176923: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
176924: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 177822: , fnd_lookup_values fvl12

177818: ELSE null
177819: END source_meaning
177820: FROM xla_events_gt xet
177821: , CST_XLA_RCV_HEADERS_V h1
177822: , fnd_lookup_values fvl12
177823: , fnd_lookup_values fvl38
177824: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
177825: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177826: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 177823: , fnd_lookup_values fvl38

177819: END source_meaning
177820: FROM xla_events_gt xet
177821: , CST_XLA_RCV_HEADERS_V h1
177822: , fnd_lookup_values fvl12
177823: , fnd_lookup_values fvl38
177824: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
177825: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177826: AND xet.event_class_code = C_EVENT_CLASS_CODE
177827: AND h1.event_id = xet.event_id

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

178080: l_balance_type_code VARCHAR2(1) :=NULL;
178081: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
178082:
178083: --
178084: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
178085: --
178086:
178087: TYPE t_array_source_12 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
178088: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 178154: , fnd_lookup_values fvl12

178150: , h1.TRANSFER_TO_GL_INDICATOR source_38
178151: , fvl38.meaning source_38_meaning
178152: FROM xla_events_gt xet
178153: , CST_XLA_RCV_HEADERS_V h1
178154: , fnd_lookup_values fvl12
178155: , fnd_lookup_values fvl38
178156: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
178157: and xet.event_class_code = C_EVENT_CLASS_CODE
178158: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 178155: , fnd_lookup_values fvl38

178151: , fvl38.meaning source_38_meaning
178152: FROM xla_events_gt xet
178153: , CST_XLA_RCV_HEADERS_V h1
178154: , fnd_lookup_values fvl12
178155: , fnd_lookup_values fvl38
178156: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
178157: and xet.event_class_code = C_EVENT_CLASS_CODE
178158: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
178159: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 179071: , fnd_lookup_values fvl12

179067: ELSE null
179068: END source_meaning
179069: FROM xla_events_gt xet
179070: , CST_XLA_INV_HEADERS_V h1
179071: , fnd_lookup_values fvl12
179072: , fnd_lookup_values fvl38
179073: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
179074: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179075: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 179072: , fnd_lookup_values fvl38

179068: END source_meaning
179069: FROM xla_events_gt xet
179070: , CST_XLA_INV_HEADERS_V h1
179071: , fnd_lookup_values fvl12
179072: , fnd_lookup_values fvl38
179073: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
179074: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179075: AND xet.event_class_code = C_EVENT_CLASS_CODE
179076: AND h1.event_id = xet.event_id

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

179349: l_balance_type_code VARCHAR2(1) :=NULL;
179350: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
179351:
179352: --
179353: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
179354: --
179355:
179356: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
179357: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 179419: , fnd_lookup_values fvl12

179415: , h1.TRANSFER_TO_GL_INDICATOR source_38
179416: , fvl38.meaning source_38_meaning
179417: FROM xla_events_gt xet
179418: , CST_XLA_INV_HEADERS_V h1
179419: , fnd_lookup_values fvl12
179420: , fnd_lookup_values fvl38
179421: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
179422: and xet.event_class_code = C_EVENT_CLASS_CODE
179423: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 179420: , fnd_lookup_values fvl38

179416: , fvl38.meaning source_38_meaning
179417: FROM xla_events_gt xet
179418: , CST_XLA_INV_HEADERS_V h1
179419: , fnd_lookup_values fvl12
179420: , fnd_lookup_values fvl38
179421: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
179422: and xet.event_class_code = C_EVENT_CLASS_CODE
179423: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
179424: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 180365: , fnd_lookup_values fvl12

180361: ELSE null
180362: END source_meaning
180363: FROM xla_events_gt xet
180364: , CST_XLA_INV_HEADERS_V h1
180365: , fnd_lookup_values fvl12
180366: , fnd_lookup_values fvl38
180367: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
180368: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180369: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 180366: , fnd_lookup_values fvl38

180362: END source_meaning
180363: FROM xla_events_gt xet
180364: , CST_XLA_INV_HEADERS_V h1
180365: , fnd_lookup_values fvl12
180366: , fnd_lookup_values fvl38
180367: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
180368: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
180369: AND xet.event_type_code = C_EVENT_TYPE_CODE
180370: AND h1.event_id = xet.event_id

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

180642: l_balance_type_code VARCHAR2(1) :=NULL;
180643: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
180644:
180645: --
180646: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
180647: --
180648:
180649: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
180650: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 180713: , fnd_lookup_values fvl12

180709: , h1.TRANSFER_TO_GL_INDICATOR source_38
180710: , fvl38.meaning source_38_meaning
180711: FROM xla_events_gt xet
180712: , CST_XLA_INV_HEADERS_V h1
180713: , fnd_lookup_values fvl12
180714: , fnd_lookup_values fvl38
180715: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
180716: and xet.event_type_code = C_EVENT_TYPE_CODE
180717: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 180714: , fnd_lookup_values fvl38

180710: , fvl38.meaning source_38_meaning
180711: FROM xla_events_gt xet
180712: , CST_XLA_INV_HEADERS_V h1
180713: , fnd_lookup_values fvl12
180714: , fnd_lookup_values fvl38
180715: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
180716: and xet.event_type_code = C_EVENT_TYPE_CODE
180717: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
180718: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 181659: , fnd_lookup_values fvl12

181655: ELSE null
181656: END source_meaning
181657: FROM xla_events_gt xet
181658: , CST_XLA_INV_HEADERS_V h1
181659: , fnd_lookup_values fvl12
181660: , fnd_lookup_values fvl38
181661: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
181662: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181663: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 181660: , fnd_lookup_values fvl38

181656: END source_meaning
181657: FROM xla_events_gt xet
181658: , CST_XLA_INV_HEADERS_V h1
181659: , fnd_lookup_values fvl12
181660: , fnd_lookup_values fvl38
181661: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
181662: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181663: AND xet.event_type_code = C_EVENT_TYPE_CODE
181664: AND h1.event_id = xet.event_id

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

181936: l_balance_type_code VARCHAR2(1) :=NULL;
181937: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
181938:
181939: --
181940: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
181941: --
181942:
181943: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
181944: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 182007: , fnd_lookup_values fvl12

182003: , h1.TRANSFER_TO_GL_INDICATOR source_38
182004: , fvl38.meaning source_38_meaning
182005: FROM xla_events_gt xet
182006: , CST_XLA_INV_HEADERS_V h1
182007: , fnd_lookup_values fvl12
182008: , fnd_lookup_values fvl38
182009: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
182010: and xet.event_type_code = C_EVENT_TYPE_CODE
182011: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 182008: , fnd_lookup_values fvl38

182004: , fvl38.meaning source_38_meaning
182005: FROM xla_events_gt xet
182006: , CST_XLA_INV_HEADERS_V h1
182007: , fnd_lookup_values fvl12
182008: , fnd_lookup_values fvl38
182009: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
182010: and xet.event_type_code = C_EVENT_TYPE_CODE
182011: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
182012: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 182895: , fnd_lookup_values fvl12

182891: ELSE null
182892: END source_meaning
182893: FROM xla_events_gt xet
182894: , CST_XLA_INV_HEADERS_V h1
182895: , fnd_lookup_values fvl12
182896: , fnd_lookup_values fvl38
182897: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
182898: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182899: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 182896: , fnd_lookup_values fvl38

182892: END source_meaning
182893: FROM xla_events_gt xet
182894: , CST_XLA_INV_HEADERS_V h1
182895: , fnd_lookup_values fvl12
182896: , fnd_lookup_values fvl38
182897: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
182898: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182899: AND xet.event_type_code = C_EVENT_TYPE_CODE
182900: AND h1.event_id = xet.event_id

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

183172: l_balance_type_code VARCHAR2(1) :=NULL;
183173: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
183174:
183175: --
183176: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
183177: --
183178:
183179: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
183180: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 183243: , fnd_lookup_values fvl12

183239: , h1.TRANSFER_TO_GL_INDICATOR source_38
183240: , fvl38.meaning source_38_meaning
183241: FROM xla_events_gt xet
183242: , CST_XLA_INV_HEADERS_V h1
183243: , fnd_lookup_values fvl12
183244: , fnd_lookup_values fvl38
183245: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183246: and xet.event_type_code = C_EVENT_TYPE_CODE
183247: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 183244: , fnd_lookup_values fvl38

183240: , fvl38.meaning source_38_meaning
183241: FROM xla_events_gt xet
183242: , CST_XLA_INV_HEADERS_V h1
183243: , fnd_lookup_values fvl12
183244: , fnd_lookup_values fvl38
183245: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
183246: and xet.event_type_code = C_EVENT_TYPE_CODE
183247: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
183248: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 184305: , fnd_lookup_values fvl12

184301: ELSE null
184302: END source_meaning
184303: FROM xla_events_gt xet
184304: , CST_XLA_INV_HEADERS_V h1
184305: , fnd_lookup_values fvl12
184306: , fnd_lookup_values fvl38
184307: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
184308: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184309: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 184306: , fnd_lookup_values fvl38

184302: END source_meaning
184303: FROM xla_events_gt xet
184304: , CST_XLA_INV_HEADERS_V h1
184305: , fnd_lookup_values fvl12
184306: , fnd_lookup_values fvl38
184307: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
184308: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184309: AND xet.event_type_code = C_EVENT_TYPE_CODE
184310: AND h1.event_id = xet.event_id

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

184582: l_balance_type_code VARCHAR2(1) :=NULL;
184583: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
184584:
184585: --
184586: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
184587: --
184588:
184589: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
184590: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 184653: , fnd_lookup_values fvl12

184649: , h1.TRANSFER_TO_GL_INDICATOR source_38
184650: , fvl38.meaning source_38_meaning
184651: FROM xla_events_gt xet
184652: , CST_XLA_INV_HEADERS_V h1
184653: , fnd_lookup_values fvl12
184654: , fnd_lookup_values fvl38
184655: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
184656: and xet.event_type_code = C_EVENT_TYPE_CODE
184657: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 184654: , fnd_lookup_values fvl38

184650: , fvl38.meaning source_38_meaning
184651: FROM xla_events_gt xet
184652: , CST_XLA_INV_HEADERS_V h1
184653: , fnd_lookup_values fvl12
184654: , fnd_lookup_values fvl38
184655: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
184656: and xet.event_type_code = C_EVENT_TYPE_CODE
184657: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
184658: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 185715: , fnd_lookup_values fvl12

185711: ELSE null
185712: END source_meaning
185713: FROM xla_events_gt xet
185714: , CST_XLA_INV_HEADERS_V h1
185715: , fnd_lookup_values fvl12
185716: , fnd_lookup_values fvl38
185717: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
185718: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185719: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 185716: , fnd_lookup_values fvl38

185712: END source_meaning
185713: FROM xla_events_gt xet
185714: , CST_XLA_INV_HEADERS_V h1
185715: , fnd_lookup_values fvl12
185716: , fnd_lookup_values fvl38
185717: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
185718: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185719: AND xet.event_type_code = C_EVENT_TYPE_CODE
185720: AND h1.event_id = xet.event_id

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

185992: l_balance_type_code VARCHAR2(1) :=NULL;
185993: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
185994:
185995: --
185996: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
185997: --
185998:
185999: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
186000: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 186063: , fnd_lookup_values fvl12

186059: , h1.TRANSFER_TO_GL_INDICATOR source_38
186060: , fvl38.meaning source_38_meaning
186061: FROM xla_events_gt xet
186062: , CST_XLA_INV_HEADERS_V h1
186063: , fnd_lookup_values fvl12
186064: , fnd_lookup_values fvl38
186065: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
186066: and xet.event_type_code = C_EVENT_TYPE_CODE
186067: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 186064: , fnd_lookup_values fvl38

186060: , fvl38.meaning source_38_meaning
186061: FROM xla_events_gt xet
186062: , CST_XLA_INV_HEADERS_V h1
186063: , fnd_lookup_values fvl12
186064: , fnd_lookup_values fvl38
186065: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
186066: and xet.event_type_code = C_EVENT_TYPE_CODE
186067: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
186068: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 187125: , fnd_lookup_values fvl12

187121: ELSE null
187122: END source_meaning
187123: FROM xla_events_gt xet
187124: , CST_XLA_INV_HEADERS_V h1
187125: , fnd_lookup_values fvl12
187126: , fnd_lookup_values fvl38
187127: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
187128: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187129: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 187126: , fnd_lookup_values fvl38

187122: END source_meaning
187123: FROM xla_events_gt xet
187124: , CST_XLA_INV_HEADERS_V h1
187125: , fnd_lookup_values fvl12
187126: , fnd_lookup_values fvl38
187127: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
187128: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
187129: AND xet.event_type_code = C_EVENT_TYPE_CODE
187130: AND h1.event_id = xet.event_id

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

187402: l_balance_type_code VARCHAR2(1) :=NULL;
187403: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
187404:
187405: --
187406: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
187407: --
187408:
187409: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
187410: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 187473: , fnd_lookup_values fvl12

187469: , h1.TRANSFER_TO_GL_INDICATOR source_38
187470: , fvl38.meaning source_38_meaning
187471: FROM xla_events_gt xet
187472: , CST_XLA_INV_HEADERS_V h1
187473: , fnd_lookup_values fvl12
187474: , fnd_lookup_values fvl38
187475: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187476: and xet.event_type_code = C_EVENT_TYPE_CODE
187477: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 187474: , fnd_lookup_values fvl38

187470: , fvl38.meaning source_38_meaning
187471: FROM xla_events_gt xet
187472: , CST_XLA_INV_HEADERS_V h1
187473: , fnd_lookup_values fvl12
187474: , fnd_lookup_values fvl38
187475: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
187476: and xet.event_type_code = C_EVENT_TYPE_CODE
187477: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
187478: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 188535: , fnd_lookup_values fvl12

188531: ELSE null
188532: END source_meaning
188533: FROM xla_events_gt xet
188534: , CST_XLA_INV_HEADERS_V h1
188535: , fnd_lookup_values fvl12
188536: , fnd_lookup_values fvl38
188537: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
188538: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188539: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 188536: , fnd_lookup_values fvl38

188532: END source_meaning
188533: FROM xla_events_gt xet
188534: , CST_XLA_INV_HEADERS_V h1
188535: , fnd_lookup_values fvl12
188536: , fnd_lookup_values fvl38
188537: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
188538: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188539: AND xet.event_type_code = C_EVENT_TYPE_CODE
188540: AND h1.event_id = xet.event_id

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

188812: l_balance_type_code VARCHAR2(1) :=NULL;
188813: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
188814:
188815: --
188816: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
188817: --
188818:
188819: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
188820: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 188883: , fnd_lookup_values fvl12

188879: , h1.TRANSFER_TO_GL_INDICATOR source_38
188880: , fvl38.meaning source_38_meaning
188881: FROM xla_events_gt xet
188882: , CST_XLA_INV_HEADERS_V h1
188883: , fnd_lookup_values fvl12
188884: , fnd_lookup_values fvl38
188885: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
188886: and xet.event_type_code = C_EVENT_TYPE_CODE
188887: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 188884: , fnd_lookup_values fvl38

188880: , fvl38.meaning source_38_meaning
188881: FROM xla_events_gt xet
188882: , CST_XLA_INV_HEADERS_V h1
188883: , fnd_lookup_values fvl12
188884: , fnd_lookup_values fvl38
188885: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
188886: and xet.event_type_code = C_EVENT_TYPE_CODE
188887: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
188888: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 189945: , fnd_lookup_values fvl12

189941: ELSE null
189942: END source_meaning
189943: FROM xla_events_gt xet
189944: , CST_XLA_INV_HEADERS_V h1
189945: , fnd_lookup_values fvl12
189946: , fnd_lookup_values fvl38
189947: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
189948: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189949: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 189946: , fnd_lookup_values fvl38

189942: END source_meaning
189943: FROM xla_events_gt xet
189944: , CST_XLA_INV_HEADERS_V h1
189945: , fnd_lookup_values fvl12
189946: , fnd_lookup_values fvl38
189947: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
189948: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189949: AND xet.event_type_code = C_EVENT_TYPE_CODE
189950: AND h1.event_id = xet.event_id

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

190222: l_balance_type_code VARCHAR2(1) :=NULL;
190223: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
190224:
190225: --
190226: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
190227: --
190228:
190229: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
190230: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 190293: , fnd_lookup_values fvl12

190289: , h1.TRANSFER_TO_GL_INDICATOR source_38
190290: , fvl38.meaning source_38_meaning
190291: FROM xla_events_gt xet
190292: , CST_XLA_INV_HEADERS_V h1
190293: , fnd_lookup_values fvl12
190294: , fnd_lookup_values fvl38
190295: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
190296: and xet.event_type_code = C_EVENT_TYPE_CODE
190297: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 190294: , fnd_lookup_values fvl38

190290: , fvl38.meaning source_38_meaning
190291: FROM xla_events_gt xet
190292: , CST_XLA_INV_HEADERS_V h1
190293: , fnd_lookup_values fvl12
190294: , fnd_lookup_values fvl38
190295: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
190296: and xet.event_type_code = C_EVENT_TYPE_CODE
190297: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
190298: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 191355: , fnd_lookup_values fvl12

191351: ELSE null
191352: END source_meaning
191353: FROM xla_events_gt xet
191354: , CST_XLA_INV_HEADERS_V h1
191355: , fnd_lookup_values fvl12
191356: , fnd_lookup_values fvl38
191357: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
191358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191359: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 191356: , fnd_lookup_values fvl38

191352: END source_meaning
191353: FROM xla_events_gt xet
191354: , CST_XLA_INV_HEADERS_V h1
191355: , fnd_lookup_values fvl12
191356: , fnd_lookup_values fvl38
191357: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
191358: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
191359: AND xet.event_type_code = C_EVENT_TYPE_CODE
191360: AND h1.event_id = xet.event_id

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

191632: l_balance_type_code VARCHAR2(1) :=NULL;
191633: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
191634:
191635: --
191636: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
191637: --
191638:
191639: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
191640: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 191703: , fnd_lookup_values fvl12

191699: , h1.TRANSFER_TO_GL_INDICATOR source_38
191700: , fvl38.meaning source_38_meaning
191701: FROM xla_events_gt xet
191702: , CST_XLA_INV_HEADERS_V h1
191703: , fnd_lookup_values fvl12
191704: , fnd_lookup_values fvl38
191705: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
191706: and xet.event_type_code = C_EVENT_TYPE_CODE
191707: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 191704: , fnd_lookup_values fvl38

191700: , fvl38.meaning source_38_meaning
191701: FROM xla_events_gt xet
191702: , CST_XLA_INV_HEADERS_V h1
191703: , fnd_lookup_values fvl12
191704: , fnd_lookup_values fvl38
191705: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
191706: and xet.event_type_code = C_EVENT_TYPE_CODE
191707: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
191708: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 192591: , fnd_lookup_values fvl12

192587: ELSE null
192588: END source_meaning
192589: FROM xla_events_gt xet
192590: , CST_XLA_INV_HEADERS_V h1
192591: , fnd_lookup_values fvl12
192592: , fnd_lookup_values fvl38
192593: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
192594: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192595: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 192592: , fnd_lookup_values fvl38

192588: END source_meaning
192589: FROM xla_events_gt xet
192590: , CST_XLA_INV_HEADERS_V h1
192591: , fnd_lookup_values fvl12
192592: , fnd_lookup_values fvl38
192593: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
192594: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192595: AND xet.event_type_code = C_EVENT_TYPE_CODE
192596: AND h1.event_id = xet.event_id

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

192868: l_balance_type_code VARCHAR2(1) :=NULL;
192869: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
192870:
192871: --
192872: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
192873: --
192874:
192875: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
192876: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 192939: , fnd_lookup_values fvl12

192935: , h1.TRANSFER_TO_GL_INDICATOR source_38
192936: , fvl38.meaning source_38_meaning
192937: FROM xla_events_gt xet
192938: , CST_XLA_INV_HEADERS_V h1
192939: , fnd_lookup_values fvl12
192940: , fnd_lookup_values fvl38
192941: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
192942: and xet.event_type_code = C_EVENT_TYPE_CODE
192943: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 192940: , fnd_lookup_values fvl38

192936: , fvl38.meaning source_38_meaning
192937: FROM xla_events_gt xet
192938: , CST_XLA_INV_HEADERS_V h1
192939: , fnd_lookup_values fvl12
192940: , fnd_lookup_values fvl38
192941: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
192942: and xet.event_type_code = C_EVENT_TYPE_CODE
192943: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
192944: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 194001: , fnd_lookup_values fvl12

193997: ELSE null
193998: END source_meaning
193999: FROM xla_events_gt xet
194000: , CST_XLA_INV_HEADERS_V h1
194001: , fnd_lookup_values fvl12
194002: , fnd_lookup_values fvl38
194003: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
194004: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194005: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 194002: , fnd_lookup_values fvl38

193998: END source_meaning
193999: FROM xla_events_gt xet
194000: , CST_XLA_INV_HEADERS_V h1
194001: , fnd_lookup_values fvl12
194002: , fnd_lookup_values fvl38
194003: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
194004: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194005: AND xet.event_type_code = C_EVENT_TYPE_CODE
194006: AND h1.event_id = xet.event_id

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

194278: l_balance_type_code VARCHAR2(1) :=NULL;
194279: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
194280:
194281: --
194282: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
194283: --
194284:
194285: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
194286: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 194349: , fnd_lookup_values fvl12

194345: , h1.TRANSFER_TO_GL_INDICATOR source_38
194346: , fvl38.meaning source_38_meaning
194347: FROM xla_events_gt xet
194348: , CST_XLA_INV_HEADERS_V h1
194349: , fnd_lookup_values fvl12
194350: , fnd_lookup_values fvl38
194351: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194352: and xet.event_type_code = C_EVENT_TYPE_CODE
194353: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 194350: , fnd_lookup_values fvl38

194346: , fvl38.meaning source_38_meaning
194347: FROM xla_events_gt xet
194348: , CST_XLA_INV_HEADERS_V h1
194349: , fnd_lookup_values fvl12
194350: , fnd_lookup_values fvl38
194351: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
194352: and xet.event_type_code = C_EVENT_TYPE_CODE
194353: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
194354: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 195411: , fnd_lookup_values fvl12

195407: ELSE null
195408: END source_meaning
195409: FROM xla_events_gt xet
195410: , CST_XLA_INV_HEADERS_V h1
195411: , fnd_lookup_values fvl12
195412: , fnd_lookup_values fvl38
195413: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
195414: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195415: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 195412: , fnd_lookup_values fvl38

195408: END source_meaning
195409: FROM xla_events_gt xet
195410: , CST_XLA_INV_HEADERS_V h1
195411: , fnd_lookup_values fvl12
195412: , fnd_lookup_values fvl38
195413: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
195414: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195415: AND xet.event_type_code = C_EVENT_TYPE_CODE
195416: AND h1.event_id = xet.event_id

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

195688: l_balance_type_code VARCHAR2(1) :=NULL;
195689: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
195690:
195691: --
195692: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
195693: --
195694:
195695: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
195696: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 195759: , fnd_lookup_values fvl12

195755: , h1.TRANSFER_TO_GL_INDICATOR source_38
195756: , fvl38.meaning source_38_meaning
195757: FROM xla_events_gt xet
195758: , CST_XLA_INV_HEADERS_V h1
195759: , fnd_lookup_values fvl12
195760: , fnd_lookup_values fvl38
195761: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
195762: and xet.event_type_code = C_EVENT_TYPE_CODE
195763: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 195760: , fnd_lookup_values fvl38

195756: , fvl38.meaning source_38_meaning
195757: FROM xla_events_gt xet
195758: , CST_XLA_INV_HEADERS_V h1
195759: , fnd_lookup_values fvl12
195760: , fnd_lookup_values fvl38
195761: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
195762: and xet.event_type_code = C_EVENT_TYPE_CODE
195763: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
195764: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 196734: , fnd_lookup_values fvl12

196730: ELSE null
196731: END source_meaning
196732: FROM xla_events_gt xet
196733: , CST_XLA_INV_HEADERS_V h1
196734: , fnd_lookup_values fvl12
196735: , fnd_lookup_values fvl38
196736: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
196737: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196738: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 196735: , fnd_lookup_values fvl38

196731: END source_meaning
196732: FROM xla_events_gt xet
196733: , CST_XLA_INV_HEADERS_V h1
196734: , fnd_lookup_values fvl12
196735: , fnd_lookup_values fvl38
196736: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
196737: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196738: AND xet.event_type_code = C_EVENT_TYPE_CODE
196739: AND h1.event_id = xet.event_id

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

197011: l_balance_type_code VARCHAR2(1) :=NULL;
197012: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
197013:
197014: --
197015: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
197016: --
197017:
197018: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
197019: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 197082: , fnd_lookup_values fvl12

197078: , h1.TRANSFER_TO_GL_INDICATOR source_38
197079: , fvl38.meaning source_38_meaning
197080: FROM xla_events_gt xet
197081: , CST_XLA_INV_HEADERS_V h1
197082: , fnd_lookup_values fvl12
197083: , fnd_lookup_values fvl38
197084: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
197085: and xet.event_type_code = C_EVENT_TYPE_CODE
197086: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 197083: , fnd_lookup_values fvl38

197079: , fvl38.meaning source_38_meaning
197080: FROM xla_events_gt xet
197081: , CST_XLA_INV_HEADERS_V h1
197082: , fnd_lookup_values fvl12
197083: , fnd_lookup_values fvl38
197084: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
197085: and xet.event_type_code = C_EVENT_TYPE_CODE
197086: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
197087: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 198057: , fnd_lookup_values fvl12

198053: ELSE null
198054: END source_meaning
198055: FROM xla_events_gt xet
198056: , CST_XLA_INV_HEADERS_V h1
198057: , fnd_lookup_values fvl12
198058: , fnd_lookup_values fvl38
198059: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
198060: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198061: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 198058: , fnd_lookup_values fvl38

198054: END source_meaning
198055: FROM xla_events_gt xet
198056: , CST_XLA_INV_HEADERS_V h1
198057: , fnd_lookup_values fvl12
198058: , fnd_lookup_values fvl38
198059: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
198060: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198061: AND xet.event_type_code = C_EVENT_TYPE_CODE
198062: AND h1.event_id = xet.event_id

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

198334: l_balance_type_code VARCHAR2(1) :=NULL;
198335: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
198336:
198337: --
198338: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
198339: --
198340:
198341: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
198342: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 198405: , fnd_lookup_values fvl12

198401: , h1.TRANSFER_TO_GL_INDICATOR source_38
198402: , fvl38.meaning source_38_meaning
198403: FROM xla_events_gt xet
198404: , CST_XLA_INV_HEADERS_V h1
198405: , fnd_lookup_values fvl12
198406: , fnd_lookup_values fvl38
198407: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
198408: and xet.event_type_code = C_EVENT_TYPE_CODE
198409: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 198406: , fnd_lookup_values fvl38

198402: , fvl38.meaning source_38_meaning
198403: FROM xla_events_gt xet
198404: , CST_XLA_INV_HEADERS_V h1
198405: , fnd_lookup_values fvl12
198406: , fnd_lookup_values fvl38
198407: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
198408: and xet.event_type_code = C_EVENT_TYPE_CODE
198409: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
198410: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 199322: , fnd_lookup_values fvl12

199318: ELSE null
199319: END source_meaning
199320: FROM xla_events_gt xet
199321: , CST_XLA_INV_HEADERS_V h1
199322: , fnd_lookup_values fvl12
199323: , fnd_lookup_values fvl38
199324: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
199325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199326: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 199323: , fnd_lookup_values fvl38

199319: END source_meaning
199320: FROM xla_events_gt xet
199321: , CST_XLA_INV_HEADERS_V h1
199322: , fnd_lookup_values fvl12
199323: , fnd_lookup_values fvl38
199324: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
199325: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
199326: AND xet.event_type_code = C_EVENT_TYPE_CODE
199327: AND h1.event_id = xet.event_id

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

199599: l_balance_type_code VARCHAR2(1) :=NULL;
199600: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
199601:
199602: --
199603: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
199604: --
199605:
199606: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
199607: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 199670: , fnd_lookup_values fvl12

199666: , h1.TRANSFER_TO_GL_INDICATOR source_38
199667: , fvl38.meaning source_38_meaning
199668: FROM xla_events_gt xet
199669: , CST_XLA_INV_HEADERS_V h1
199670: , fnd_lookup_values fvl12
199671: , fnd_lookup_values fvl38
199672: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
199673: and xet.event_type_code = C_EVENT_TYPE_CODE
199674: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 199671: , fnd_lookup_values fvl38

199667: , fvl38.meaning source_38_meaning
199668: FROM xla_events_gt xet
199669: , CST_XLA_INV_HEADERS_V h1
199670: , fnd_lookup_values fvl12
199671: , fnd_lookup_values fvl38
199672: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
199673: and xet.event_type_code = C_EVENT_TYPE_CODE
199674: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
199675: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 200558: , fnd_lookup_values fvl12

200554: ELSE null
200555: END source_meaning
200556: FROM xla_events_gt xet
200557: , CST_XLA_INV_HEADERS_V h1
200558: , fnd_lookup_values fvl12
200559: , fnd_lookup_values fvl38
200560: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
200561: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
200562: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 200559: , fnd_lookup_values fvl38

200555: END source_meaning
200556: FROM xla_events_gt xet
200557: , CST_XLA_INV_HEADERS_V h1
200558: , fnd_lookup_values fvl12
200559: , fnd_lookup_values fvl38
200560: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
200561: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
200562: AND xet.event_type_code = C_EVENT_TYPE_CODE
200563: AND h1.event_id = xet.event_id

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

200835: l_balance_type_code VARCHAR2(1) :=NULL;
200836: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
200837:
200838: --
200839: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
200840: --
200841:
200842: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
200843: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 200906: , fnd_lookup_values fvl12

200902: , h1.TRANSFER_TO_GL_INDICATOR source_38
200903: , fvl38.meaning source_38_meaning
200904: FROM xla_events_gt xet
200905: , CST_XLA_INV_HEADERS_V h1
200906: , fnd_lookup_values fvl12
200907: , fnd_lookup_values fvl38
200908: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
200909: and xet.event_type_code = C_EVENT_TYPE_CODE
200910: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 200907: , fnd_lookup_values fvl38

200903: , fvl38.meaning source_38_meaning
200904: FROM xla_events_gt xet
200905: , CST_XLA_INV_HEADERS_V h1
200906: , fnd_lookup_values fvl12
200907: , fnd_lookup_values fvl38
200908: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
200909: and xet.event_type_code = C_EVENT_TYPE_CODE
200910: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
200911: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 201794: , fnd_lookup_values fvl12

201790: ELSE null
201791: END source_meaning
201792: FROM xla_events_gt xet
201793: , CST_XLA_INV_HEADERS_V h1
201794: , fnd_lookup_values fvl12
201795: , fnd_lookup_values fvl38
201796: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
201797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201798: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 201795: , fnd_lookup_values fvl38

201791: END source_meaning
201792: FROM xla_events_gt xet
201793: , CST_XLA_INV_HEADERS_V h1
201794: , fnd_lookup_values fvl12
201795: , fnd_lookup_values fvl38
201796: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
201797: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
201798: AND xet.event_type_code = C_EVENT_TYPE_CODE
201799: AND h1.event_id = xet.event_id

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

202071: l_balance_type_code VARCHAR2(1) :=NULL;
202072: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
202073:
202074: --
202075: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
202076: --
202077:
202078: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
202079: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 202142: , fnd_lookup_values fvl12

202138: , h1.TRANSFER_TO_GL_INDICATOR source_38
202139: , fvl38.meaning source_38_meaning
202140: FROM xla_events_gt xet
202141: , CST_XLA_INV_HEADERS_V h1
202142: , fnd_lookup_values fvl12
202143: , fnd_lookup_values fvl38
202144: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
202145: and xet.event_type_code = C_EVENT_TYPE_CODE
202146: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 202143: , fnd_lookup_values fvl38

202139: , fvl38.meaning source_38_meaning
202140: FROM xla_events_gt xet
202141: , CST_XLA_INV_HEADERS_V h1
202142: , fnd_lookup_values fvl12
202143: , fnd_lookup_values fvl38
202144: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
202145: and xet.event_type_code = C_EVENT_TYPE_CODE
202146: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
202147: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 203050: , fnd_lookup_values fvl12

203046: ELSE null
203047: END source_meaning
203048: FROM xla_events_gt xet
203049: , CST_XLA_WIP_HEADERS_V h1
203050: , fnd_lookup_values fvl12
203051: , fnd_lookup_values fvl38
203052: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
203053: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
203054: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 203051: , fnd_lookup_values fvl38

203047: END source_meaning
203048: FROM xla_events_gt xet
203049: , CST_XLA_WIP_HEADERS_V h1
203050: , fnd_lookup_values fvl12
203051: , fnd_lookup_values fvl38
203052: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
203053: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
203054: AND xet.event_class_code = C_EVENT_CLASS_CODE
203055: AND h1.event_id = xet.event_id

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

203308: l_balance_type_code VARCHAR2(1) :=NULL;
203309: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
203310:
203311: --
203312: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
203313: --
203314:
203315: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
203316: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 203382: , fnd_lookup_values fvl12

203378: , h1.TRANSFER_TO_GL_INDICATOR source_38
203379: , fvl38.meaning source_38_meaning
203380: FROM xla_events_gt xet
203381: , CST_XLA_WIP_HEADERS_V h1
203382: , fnd_lookup_values fvl12
203383: , fnd_lookup_values fvl38
203384: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
203385: and xet.event_class_code = C_EVENT_CLASS_CODE
203386: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 203383: , fnd_lookup_values fvl38

203379: , fvl38.meaning source_38_meaning
203380: FROM xla_events_gt xet
203381: , CST_XLA_WIP_HEADERS_V h1
203382: , fnd_lookup_values fvl12
203383: , fnd_lookup_values fvl38
203384: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
203385: and xet.event_class_code = C_EVENT_CLASS_CODE
203386: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
203387: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 204261: , fnd_lookup_values fvl12

204257: ELSE null
204258: END source_meaning
204259: FROM xla_events_gt xet
204260: , CST_XLA_WIP_HEADERS_V h1
204261: , fnd_lookup_values fvl12
204262: , fnd_lookup_values fvl38
204263: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
204264: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204265: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 204262: , fnd_lookup_values fvl38

204258: END source_meaning
204259: FROM xla_events_gt xet
204260: , CST_XLA_WIP_HEADERS_V h1
204261: , fnd_lookup_values fvl12
204262: , fnd_lookup_values fvl38
204263: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
204264: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
204265: AND xet.event_class_code = C_EVENT_CLASS_CODE
204266: AND h1.event_id = xet.event_id

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

204519: l_balance_type_code VARCHAR2(1) :=NULL;
204520: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
204521:
204522: --
204523: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
204524: --
204525:
204526: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
204527: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 204593: , fnd_lookup_values fvl12

204589: , h1.TRANSFER_TO_GL_INDICATOR source_38
204590: , fvl38.meaning source_38_meaning
204591: FROM xla_events_gt xet
204592: , CST_XLA_WIP_HEADERS_V h1
204593: , fnd_lookup_values fvl12
204594: , fnd_lookup_values fvl38
204595: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
204596: and xet.event_class_code = C_EVENT_CLASS_CODE
204597: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 204594: , fnd_lookup_values fvl38

204590: , fvl38.meaning source_38_meaning
204591: FROM xla_events_gt xet
204592: , CST_XLA_WIP_HEADERS_V h1
204593: , fnd_lookup_values fvl12
204594: , fnd_lookup_values fvl38
204595: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
204596: and xet.event_class_code = C_EVENT_CLASS_CODE
204597: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
204598: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 205472: , fnd_lookup_values fvl12

205468: ELSE null
205469: END source_meaning
205470: FROM xla_events_gt xet
205471: , CST_XLA_WIP_HEADERS_V h1
205472: , fnd_lookup_values fvl12
205473: , fnd_lookup_values fvl38
205474: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
205475: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
205476: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 205473: , fnd_lookup_values fvl38

205469: END source_meaning
205470: FROM xla_events_gt xet
205471: , CST_XLA_WIP_HEADERS_V h1
205472: , fnd_lookup_values fvl12
205473: , fnd_lookup_values fvl38
205474: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
205475: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
205476: AND xet.event_class_code = C_EVENT_CLASS_CODE
205477: AND h1.event_id = xet.event_id

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

205730: l_balance_type_code VARCHAR2(1) :=NULL;
205731: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
205732:
205733: --
205734: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
205735: --
205736:
205737: TYPE t_array_source_12 IS TABLE OF CST_XLA_WIP_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
205738: TYPE t_array_source_15 IS TABLE OF CST_XLA_WIP_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 205804: , fnd_lookup_values fvl12

205800: , h1.TRANSFER_TO_GL_INDICATOR source_38
205801: , fvl38.meaning source_38_meaning
205802: FROM xla_events_gt xet
205803: , CST_XLA_WIP_HEADERS_V h1
205804: , fnd_lookup_values fvl12
205805: , fnd_lookup_values fvl38
205806: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
205807: and xet.event_class_code = C_EVENT_CLASS_CODE
205808: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 205805: , fnd_lookup_values fvl38

205801: , fvl38.meaning source_38_meaning
205802: FROM xla_events_gt xet
205803: , CST_XLA_WIP_HEADERS_V h1
205804: , fnd_lookup_values fvl12
205805: , fnd_lookup_values fvl38
205806: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
205807: and xet.event_class_code = C_EVENT_CLASS_CODE
205808: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
205809: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 206663: , fnd_lookup_values fvl12

206659: ELSE null
206660: END source_meaning
206661: FROM xla_events_gt xet
206662: , CST_XLA_INV_HEADERS_V h1
206663: , fnd_lookup_values fvl12
206664: , fnd_lookup_values fvl38
206665: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
206666: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
206667: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 206664: , fnd_lookup_values fvl38

206660: END source_meaning
206661: FROM xla_events_gt xet
206662: , CST_XLA_INV_HEADERS_V h1
206663: , fnd_lookup_values fvl12
206664: , fnd_lookup_values fvl38
206665: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
206666: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
206667: AND xet.event_class_code = C_EVENT_CLASS_CODE
206668: AND h1.event_id = xet.event_id

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

206941: l_balance_type_code VARCHAR2(1) :=NULL;
206942: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
206943:
206944: --
206945: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
206946: --
206947:
206948: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
206949: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 207011: , fnd_lookup_values fvl12

207007: , h1.TRANSFER_TO_GL_INDICATOR source_38
207008: , fvl38.meaning source_38_meaning
207009: FROM xla_events_gt xet
207010: , CST_XLA_INV_HEADERS_V h1
207011: , fnd_lookup_values fvl12
207012: , fnd_lookup_values fvl38
207013: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
207014: and xet.event_class_code = C_EVENT_CLASS_CODE
207015: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 207012: , fnd_lookup_values fvl38

207008: , fvl38.meaning source_38_meaning
207009: FROM xla_events_gt xet
207010: , CST_XLA_INV_HEADERS_V h1
207011: , fnd_lookup_values fvl12
207012: , fnd_lookup_values fvl38
207013: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
207014: and xet.event_class_code = C_EVENT_CLASS_CODE
207015: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
207016: AND fvl12.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'