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_000007_PKG dependencies on XLA_EVENTS_GT

Line 138226: FROM xla_events_gt xet

138222: WHEN 6 THEN fvl38.meaning
138223:
138224: ELSE null
138225: END source_meaning
138226: FROM xla_events_gt xet
138227: , CST_XLA_WIP_HEADERS_V h1
138228: , fnd_lookup_values fvl12
138229: , fnd_lookup_values fvl38
138230: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

Line 138354: FROM xla_events_gt xet

138350:
138351: ELSE null
138352: END source_value
138353: , null source_meaning
138354: FROM xla_events_gt xet
138355: , CST_XLA_WIP_LINES_V l2
138356: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
138357: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
138358: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 138558: FROM xla_events_gt xet

138554: , h1.CURRENCY_CONVERSION_RATE source_20
138555: , h1.CURRENCY_CONVERSION_TYPE source_21
138556: , h1.TRANSFER_TO_GL_INDICATOR source_38
138557: , fvl38.meaning source_38_meaning
138558: FROM xla_events_gt xet
138559: , CST_XLA_WIP_HEADERS_V h1
138560: , fnd_lookup_values fvl12
138561: , fnd_lookup_values fvl38
138562: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 138613: FROM xla_events_gt xet

138609: , l2.DISTRIBUTION_IDENTIFIER source_11
138610: , l2.ENTERED_AMOUNT source_18
138611: , l2.ACCOUNTED_AMOUNT source_22
138612: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
138613: FROM xla_events_gt xet
138614: , CST_XLA_WIP_LINES_V l2
138615: WHERE xet.event_id between x_first_event_id and x_last_event_id
138616: and xet.event_date between p_pad_start_date and p_pad_end_date
138617: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 139524: FROM xla_events_gt xet

139520: WHEN 6 THEN fvl38.meaning
139521:
139522: ELSE null
139523: END source_meaning
139524: FROM xla_events_gt xet
139525: , CST_XLA_AWO_HEADERS_V h1
139526: , fnd_lookup_values fvl12
139527: , fnd_lookup_values fvl38
139528: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

Line 139662: FROM xla_events_gt xet

139658:
139659: ELSE null
139660: END source_value
139661: , null source_meaning
139662: FROM xla_events_gt xet
139663: , CST_XLA_AWO_LINES_V l2
139664: , (select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
139665: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
139666: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 139870: FROM xla_events_gt xet

139866: , fvl12.meaning source_12_meaning
139867: , h1.WRITE_OFF_ID source_26
139868: , h1.TRANSFER_TO_GL_INDICATOR source_38
139869: , fvl38.meaning source_38_meaning
139870: FROM xla_events_gt xet
139871: , CST_XLA_AWO_HEADERS_V h1
139872: , fnd_lookup_values fvl12
139873: , fnd_lookup_values fvl38
139874: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 139927: FROM xla_events_gt xet

139923: , l2.CURRENCY_CONVERSION_RATE source_20
139924: , l2.CURRENCY_CONVERSION_TYPE source_21
139925: , l2.ACCOUNTED_AMOUNT source_22
139926: , l2.LINE_NUMBER source_25
139927: FROM xla_events_gt xet
139928: , CST_XLA_AWO_LINES_V l2
139929: WHERE xet.event_id between x_first_event_id and x_last_event_id
139930: and xet.event_date between p_pad_start_date and p_pad_end_date
139931: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 140791: FROM xla_events_gt xet

140787: WHEN 2 THEN fvl38.meaning
140788:
140789: ELSE null
140790: END source_meaning
140791: FROM xla_events_gt xet
140792: , CST_XLA_INV_HEADERS_V h1
140793: , fnd_lookup_values fvl12
140794: , fnd_lookup_values fvl38
140795: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 140939: FROM xla_events_gt xet

140935:
140936: ELSE null
140937: END source_value
140938: , null source_meaning
140939: FROM xla_events_gt xet
140940: , CST_XLA_INV_LINES_V l2
140941: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
140942: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
140943: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 141139: FROM xla_events_gt xet

141135: , h1.DISTRIBUTION_TYPE source_12
141136: , fvl12.meaning source_12_meaning
141137: , h1.TRANSFER_TO_GL_INDICATOR source_38
141138: , fvl38.meaning source_38_meaning
141139: FROM xla_events_gt xet
141140: , CST_XLA_INV_HEADERS_V h1
141141: , fnd_lookup_values fvl12
141142: , fnd_lookup_values fvl38
141143: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 141198: FROM xla_events_gt xet

141194: , l2.CURRENCY_CONVERSION_RATE source_20
141195: , l2.CURRENCY_CONVERSION_TYPE source_21
141196: , l2.ACCOUNTED_AMOUNT source_22
141197: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
141198: FROM xla_events_gt xet
141199: , CST_XLA_INV_LINES_V l2
141200: WHERE xet.event_id between x_first_event_id and x_last_event_id
141201: and xet.event_date between p_pad_start_date and p_pad_end_date
141202: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 142155: FROM xla_events_gt xet

142151: WHEN 16 THEN fvl38.meaning
142152:
142153: ELSE null
142154: END source_meaning
142155: FROM xla_events_gt xet
142156: , CST_XLA_RCV_HEADERS_V h1
142157: , CST_XLA_RCV_REF_V h3
142158: , PO_DISTS_REF_V h4
142159: , PO_HEADERS_REF_V h5

Line 142287: FROM xla_events_gt xet

142283:
142284: ELSE null
142285: END source_value
142286: , null source_meaning
142287: FROM xla_events_gt xet
142288: , CST_XLA_RCV_LINES_V l2
142289: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
142290: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
142291: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 142521: FROM xla_events_gt xet

142517: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_23
142518: , h6.CST_ENCUM_UPG_OPTION source_27
142519: , h1.TRANSFER_TO_GL_INDICATOR source_38
142520: , fvl38.meaning source_38_meaning
142521: FROM xla_events_gt xet
142522: , CST_XLA_RCV_HEADERS_V h1
142523: , CST_XLA_RCV_REF_V h3
142524: , PO_DISTS_REF_V h4
142525: , PO_HEADERS_REF_V h5

Line 142580: FROM xla_events_gt xet

142576: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
142577: , l2.DISTRIBUTION_IDENTIFIER source_11
142578: , l2.ENTERED_AMOUNT source_18
142579: , l2.ACCOUNTED_AMOUNT source_22
142580: FROM xla_events_gt xet
142581: , CST_XLA_RCV_LINES_V l2
142582: WHERE xet.event_id between x_first_event_id and x_last_event_id
142583: and xet.event_date between p_pad_start_date and p_pad_end_date
142584: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 143476: FROM xla_events_gt xet

143472: WHEN 12 THEN fvl38.meaning
143473:
143474: ELSE null
143475: END source_meaning
143476: FROM xla_events_gt xet
143477: , CST_XLA_INV_HEADERS_V h1
143478: , CST_XLA_INV_REF_V h3
143479: , PO_REQ_DISTS_REF_V h4
143480: , PO_REQ_HEADERS_REF_V h5

Line 143628: FROM xla_events_gt xet

143624:
143625: ELSE null
143626: END source_value
143627: , null source_meaning
143628: FROM xla_events_gt xet
143629: , CST_XLA_INV_LINES_V l2
143630: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
143631: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
143632: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 143858: FROM xla_events_gt xet

143854: , h4.REQ_BUDGET_ACCOUNT source_30
143855: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
143856: , h1.TRANSFER_TO_GL_INDICATOR source_38
143857: , fvl38.meaning source_38_meaning
143858: FROM xla_events_gt xet
143859: , CST_XLA_INV_HEADERS_V h1
143860: , CST_XLA_INV_REF_V h3
143861: , PO_REQ_DISTS_REF_V h4
143862: , PO_REQ_HEADERS_REF_V h5

Line 143921: FROM xla_events_gt xet

143917: , l2.CURRENCY_CONVERSION_RATE source_20
143918: , l2.CURRENCY_CONVERSION_TYPE source_21
143919: , l2.ACCOUNTED_AMOUNT source_22
143920: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
143921: FROM xla_events_gt xet
143922: , CST_XLA_INV_LINES_V l2
143923: WHERE xet.event_id between x_first_event_id and x_last_event_id
143924: and xet.event_date between p_pad_start_date and p_pad_end_date
143925: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 145036: FROM xla_events_gt xet

145032: WHEN 2 THEN fvl38.meaning
145033:
145034: ELSE null
145035: END source_meaning
145036: FROM xla_events_gt xet
145037: , CST_XLA_INV_HEADERS_V h1
145038: , fnd_lookup_values fvl12
145039: , fnd_lookup_values fvl38
145040: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 145184: FROM xla_events_gt xet

145180:
145181: ELSE null
145182: END source_value
145183: , null source_meaning
145184: FROM xla_events_gt xet
145185: , CST_XLA_INV_LINES_V l2
145186: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
145187: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
145188: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 145384: FROM xla_events_gt xet

145380: , h1.DISTRIBUTION_TYPE source_12
145381: , fvl12.meaning source_12_meaning
145382: , h1.TRANSFER_TO_GL_INDICATOR source_38
145383: , fvl38.meaning source_38_meaning
145384: FROM xla_events_gt xet
145385: , CST_XLA_INV_HEADERS_V h1
145386: , fnd_lookup_values fvl12
145387: , fnd_lookup_values fvl38
145388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 145443: FROM xla_events_gt xet

145439: , l2.CURRENCY_CONVERSION_RATE source_20
145440: , l2.CURRENCY_CONVERSION_TYPE source_21
145441: , l2.ACCOUNTED_AMOUNT source_22
145442: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
145443: FROM xla_events_gt xet
145444: , CST_XLA_INV_LINES_V l2
145445: WHERE xet.event_id between x_first_event_id and x_last_event_id
145446: and xet.event_date between p_pad_start_date and p_pad_end_date
145447: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 146496: FROM xla_events_gt xet

146492: WHEN 12 THEN fvl38.meaning
146493:
146494: ELSE null
146495: END source_meaning
146496: FROM xla_events_gt xet
146497: , CST_XLA_INV_HEADERS_V h1
146498: , CST_XLA_INV_REF_V h3
146499: , PO_REQ_DISTS_REF_V h4
146500: , PO_REQ_HEADERS_REF_V h5

Line 146648: FROM xla_events_gt xet

146644:
146645: ELSE null
146646: END source_value
146647: , null source_meaning
146648: FROM xla_events_gt xet
146649: , CST_XLA_INV_LINES_V l2
146650: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
146651: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
146652: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 146878: FROM xla_events_gt xet

146874: , h4.REQ_BUDGET_ACCOUNT source_30
146875: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
146876: , h1.TRANSFER_TO_GL_INDICATOR source_38
146877: , fvl38.meaning source_38_meaning
146878: FROM xla_events_gt xet
146879: , CST_XLA_INV_HEADERS_V h1
146880: , CST_XLA_INV_REF_V h3
146881: , PO_REQ_DISTS_REF_V h4
146882: , PO_REQ_HEADERS_REF_V h5

Line 146941: FROM xla_events_gt xet

146937: , l2.CURRENCY_CONVERSION_RATE source_20
146938: , l2.CURRENCY_CONVERSION_TYPE source_21
146939: , l2.ACCOUNTED_AMOUNT source_22
146940: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
146941: FROM xla_events_gt xet
146942: , CST_XLA_INV_LINES_V l2
146943: WHERE xet.event_id between x_first_event_id and x_last_event_id
146944: and xet.event_date between p_pad_start_date and p_pad_end_date
146945: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 148017: FROM xla_events_gt xet

148013: WHEN 2 THEN fvl38.meaning
148014:
148015: ELSE null
148016: END source_meaning
148017: FROM xla_events_gt xet
148018: , CST_XLA_INV_HEADERS_V h1
148019: , fnd_lookup_values fvl12
148020: , fnd_lookup_values fvl38
148021: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 148165: FROM xla_events_gt xet

148161:
148162: ELSE null
148163: END source_value
148164: , null source_meaning
148165: FROM xla_events_gt xet
148166: , CST_XLA_INV_LINES_V l2
148167: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
148168: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
148169: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 148365: FROM xla_events_gt xet

148361: , h1.DISTRIBUTION_TYPE source_12
148362: , fvl12.meaning source_12_meaning
148363: , h1.TRANSFER_TO_GL_INDICATOR source_38
148364: , fvl38.meaning source_38_meaning
148365: FROM xla_events_gt xet
148366: , CST_XLA_INV_HEADERS_V h1
148367: , fnd_lookup_values fvl12
148368: , fnd_lookup_values fvl38
148369: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 148424: FROM xla_events_gt xet

148420: , l2.CURRENCY_CONVERSION_RATE source_20
148421: , l2.CURRENCY_CONVERSION_TYPE source_21
148422: , l2.ACCOUNTED_AMOUNT source_22
148423: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
148424: FROM xla_events_gt xet
148425: , CST_XLA_INV_LINES_V l2
148426: WHERE xet.event_id between x_first_event_id and x_last_event_id
148427: and xet.event_date between p_pad_start_date and p_pad_end_date
148428: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 149369: FROM xla_events_gt xet

149365: WHEN 2 THEN fvl38.meaning
149366:
149367: ELSE null
149368: END source_meaning
149369: FROM xla_events_gt xet
149370: , CST_XLA_INV_HEADERS_V h1
149371: , fnd_lookup_values fvl12
149372: , fnd_lookup_values fvl38
149373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 149517: FROM xla_events_gt xet

149513:
149514: ELSE null
149515: END source_value
149516: , null source_meaning
149517: FROM xla_events_gt xet
149518: , CST_XLA_INV_LINES_V l2
149519: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
149520: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
149521: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 149717: FROM xla_events_gt xet

149713: , h1.DISTRIBUTION_TYPE source_12
149714: , fvl12.meaning source_12_meaning
149715: , h1.TRANSFER_TO_GL_INDICATOR source_38
149716: , fvl38.meaning source_38_meaning
149717: FROM xla_events_gt xet
149718: , CST_XLA_INV_HEADERS_V h1
149719: , fnd_lookup_values fvl12
149720: , fnd_lookup_values fvl38
149721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 149776: FROM xla_events_gt xet

149772: , l2.CURRENCY_CONVERSION_RATE source_20
149773: , l2.CURRENCY_CONVERSION_TYPE source_21
149774: , l2.ACCOUNTED_AMOUNT source_22
149775: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
149776: FROM xla_events_gt xet
149777: , CST_XLA_INV_LINES_V l2
149778: WHERE xet.event_id between x_first_event_id and x_last_event_id
149779: and xet.event_date between p_pad_start_date and p_pad_end_date
149780: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 150655: FROM xla_events_gt xet

150651: WHEN 12 THEN fvl38.meaning
150652:
150653: ELSE null
150654: END source_meaning
150655: FROM xla_events_gt xet
150656: , CST_XLA_INV_HEADERS_V h1
150657: , CST_XLA_INV_REF_V h3
150658: , PO_REQ_DISTS_REF_V h4
150659: , PO_REQ_HEADERS_REF_V h5

Line 150807: FROM xla_events_gt xet

150803:
150804: ELSE null
150805: END source_value
150806: , null source_meaning
150807: FROM xla_events_gt xet
150808: , CST_XLA_INV_LINES_V l2
150809: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
150810: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
150811: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 151037: FROM xla_events_gt xet

151033: , h4.REQ_BUDGET_ACCOUNT source_30
151034: , h5.REQ_ENCUMBRANCE_TYPE_ID source_31
151035: , h1.TRANSFER_TO_GL_INDICATOR source_38
151036: , fvl38.meaning source_38_meaning
151037: FROM xla_events_gt xet
151038: , CST_XLA_INV_HEADERS_V h1
151039: , CST_XLA_INV_REF_V h3
151040: , PO_REQ_DISTS_REF_V h4
151041: , PO_REQ_HEADERS_REF_V h5

Line 151100: FROM xla_events_gt xet

151096: , l2.CURRENCY_CONVERSION_RATE source_20
151097: , l2.CURRENCY_CONVERSION_TYPE source_21
151098: , l2.ACCOUNTED_AMOUNT source_22
151099: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
151100: FROM xla_events_gt xet
151101: , CST_XLA_INV_LINES_V l2
151102: WHERE xet.event_id between x_first_event_id and x_last_event_id
151103: and xet.event_date between p_pad_start_date and p_pad_end_date
151104: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 151981: FROM xla_events_gt xet

151977: WHEN 2 THEN fvl38.meaning
151978:
151979: ELSE null
151980: END source_meaning
151981: FROM xla_events_gt xet
151982: , CST_XLA_INV_HEADERS_V h1
151983: , fnd_lookup_values fvl12
151984: , fnd_lookup_values fvl38
151985: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 152129: FROM xla_events_gt xet

152125:
152126: ELSE null
152127: END source_value
152128: , null source_meaning
152129: FROM xla_events_gt xet
152130: , CST_XLA_INV_LINES_V l2
152131: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
152132: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
152133: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 152329: FROM xla_events_gt xet

152325: , h1.DISTRIBUTION_TYPE source_12
152326: , fvl12.meaning source_12_meaning
152327: , h1.TRANSFER_TO_GL_INDICATOR source_38
152328: , fvl38.meaning source_38_meaning
152329: FROM xla_events_gt xet
152330: , CST_XLA_INV_HEADERS_V h1
152331: , fnd_lookup_values fvl12
152332: , fnd_lookup_values fvl38
152333: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 152388: FROM xla_events_gt xet

152384: , l2.CURRENCY_CONVERSION_RATE source_20
152385: , l2.CURRENCY_CONVERSION_TYPE source_21
152386: , l2.ACCOUNTED_AMOUNT source_22
152387: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
152388: FROM xla_events_gt xet
152389: , CST_XLA_INV_LINES_V l2
152390: WHERE xet.event_id between x_first_event_id and x_last_event_id
152391: and xet.event_date between p_pad_start_date and p_pad_end_date
152392: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 153391: FROM xla_events_gt xet

153387: WHEN 2 THEN fvl38.meaning
153388:
153389: ELSE null
153390: END source_meaning
153391: FROM xla_events_gt xet
153392: , CST_XLA_INV_HEADERS_V h1
153393: , fnd_lookup_values fvl12
153394: , fnd_lookup_values fvl38
153395: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 153539: FROM xla_events_gt xet

153535:
153536: ELSE null
153537: END source_value
153538: , null source_meaning
153539: FROM xla_events_gt xet
153540: , CST_XLA_INV_LINES_V l2
153541: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
153542: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
153543: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 153739: FROM xla_events_gt xet

153735: , h1.DISTRIBUTION_TYPE source_12
153736: , fvl12.meaning source_12_meaning
153737: , h1.TRANSFER_TO_GL_INDICATOR source_38
153738: , fvl38.meaning source_38_meaning
153739: FROM xla_events_gt xet
153740: , CST_XLA_INV_HEADERS_V h1
153741: , fnd_lookup_values fvl12
153742: , fnd_lookup_values fvl38
153743: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 153798: FROM xla_events_gt xet

153794: , l2.CURRENCY_CONVERSION_RATE source_20
153795: , l2.CURRENCY_CONVERSION_TYPE source_21
153796: , l2.ACCOUNTED_AMOUNT source_22
153797: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
153798: FROM xla_events_gt xet
153799: , CST_XLA_INV_LINES_V l2
153800: WHERE xet.event_id between x_first_event_id and x_last_event_id
153801: and xet.event_date between p_pad_start_date and p_pad_end_date
153802: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 154714: FROM xla_events_gt xet

154710: WHEN 2 THEN fvl38.meaning
154711:
154712: ELSE null
154713: END source_meaning
154714: FROM xla_events_gt xet
154715: , CST_XLA_INV_HEADERS_V h1
154716: , fnd_lookup_values fvl12
154717: , fnd_lookup_values fvl38
154718: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 154862: FROM xla_events_gt xet

154858:
154859: ELSE null
154860: END source_value
154861: , null source_meaning
154862: FROM xla_events_gt xet
154863: , CST_XLA_INV_LINES_V l2
154864: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
154865: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
154866: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 155062: FROM xla_events_gt xet

155058: , h1.DISTRIBUTION_TYPE source_12
155059: , fvl12.meaning source_12_meaning
155060: , h1.TRANSFER_TO_GL_INDICATOR source_38
155061: , fvl38.meaning source_38_meaning
155062: FROM xla_events_gt xet
155063: , CST_XLA_INV_HEADERS_V h1
155064: , fnd_lookup_values fvl12
155065: , fnd_lookup_values fvl38
155066: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 155121: FROM xla_events_gt xet

155117: , l2.CURRENCY_CONVERSION_RATE source_20
155118: , l2.CURRENCY_CONVERSION_TYPE source_21
155119: , l2.ACCOUNTED_AMOUNT source_22
155120: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
155121: FROM xla_events_gt xet
155122: , CST_XLA_INV_LINES_V l2
155123: WHERE xet.event_id between x_first_event_id and x_last_event_id
155124: and xet.event_date between p_pad_start_date and p_pad_end_date
155125: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 155950: FROM xla_events_gt xet

155946: WHEN 2 THEN fvl38.meaning
155947:
155948: ELSE null
155949: END source_meaning
155950: FROM xla_events_gt xet
155951: , CST_XLA_INV_HEADERS_V h1
155952: , fnd_lookup_values fvl12
155953: , fnd_lookup_values fvl38
155954: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 156098: FROM xla_events_gt xet

156094:
156095: ELSE null
156096: END source_value
156097: , null source_meaning
156098: FROM xla_events_gt xet
156099: , CST_XLA_INV_LINES_V l2
156100: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
156101: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
156102: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 156298: FROM xla_events_gt xet

156294: , h1.DISTRIBUTION_TYPE source_12
156295: , fvl12.meaning source_12_meaning
156296: , h1.TRANSFER_TO_GL_INDICATOR source_38
156297: , fvl38.meaning source_38_meaning
156298: FROM xla_events_gt xet
156299: , CST_XLA_INV_HEADERS_V h1
156300: , fnd_lookup_values fvl12
156301: , fnd_lookup_values fvl38
156302: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 156357: FROM xla_events_gt xet

156353: , l2.CURRENCY_CONVERSION_RATE source_20
156354: , l2.CURRENCY_CONVERSION_TYPE source_21
156355: , l2.ACCOUNTED_AMOUNT source_22
156356: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
156357: FROM xla_events_gt xet
156358: , CST_XLA_INV_LINES_V l2
156359: WHERE xet.event_id between x_first_event_id and x_last_event_id
156360: and xet.event_date between p_pad_start_date and p_pad_end_date
156361: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 157259: FROM xla_events_gt xet

157255: WHEN 5 THEN fvl38.meaning
157256:
157257: ELSE null
157258: END source_meaning
157259: FROM xla_events_gt xet
157260: , CST_XLA_RCV_HEADERS_V h1
157261: , CST_XLA_RCV_REF_V h3
157262: , PO_DISTS_REF_V h4
157263: , fnd_lookup_values fvl12

Line 157389: FROM xla_events_gt xet

157385:
157386: ELSE null
157387: END source_value
157388: , null source_meaning
157389: FROM xla_events_gt xet
157390: , CST_XLA_RCV_LINES_V l2
157391: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
157392: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
157393: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 157590: FROM xla_events_gt xet

157586: , h4.CURRENCY_CONVERSION_DATE source_33
157587: , h4.CURRENCY_CONVERSION_RATE source_34
157588: , h1.TRANSFER_TO_GL_INDICATOR source_38
157589: , fvl38.meaning source_38_meaning
157590: FROM xla_events_gt xet
157591: , CST_XLA_RCV_HEADERS_V h1
157592: , CST_XLA_RCV_REF_V h3
157593: , PO_DISTS_REF_V h4
157594: , fnd_lookup_values fvl12

Line 157647: FROM xla_events_gt xet

157643: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
157644: , l2.DISTRIBUTION_IDENTIFIER source_11
157645: , l2.ENTERED_AMOUNT source_18
157646: , l2.ACCOUNTED_AMOUNT source_22
157647: FROM xla_events_gt xet
157648: , CST_XLA_RCV_LINES_V l2
157649: WHERE xet.event_id between x_first_event_id and x_last_event_id
157650: and xet.event_date between p_pad_start_date and p_pad_end_date
157651: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 158523: FROM xla_events_gt xet

158519: WHEN 6 THEN fvl38.meaning
158520:
158521: ELSE null
158522: END source_meaning
158523: FROM xla_events_gt xet
158524: , CST_XLA_RCV_HEADERS_V h1
158525: , CST_XLA_RCV_REF_V h3
158526: , PO_DISTS_REF_V h4
158527: , fnd_lookup_values fvl12

Line 158653: FROM xla_events_gt xet

158649:
158650: ELSE null
158651: END source_value
158652: , null source_meaning
158653: FROM xla_events_gt xet
158654: , CST_XLA_RCV_LINES_V l2
158655: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
158656: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
158657: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 158857: FROM xla_events_gt xet

158853: , h4.CURRENCY_CONVERSION_RATE source_34
158854: , h4.CURRENCY_CONVERSION_TYPE source_36
158855: , h1.TRANSFER_TO_GL_INDICATOR source_38
158856: , fvl38.meaning source_38_meaning
158857: FROM xla_events_gt xet
158858: , CST_XLA_RCV_HEADERS_V h1
158859: , CST_XLA_RCV_REF_V h3
158860: , PO_DISTS_REF_V h4
158861: , fnd_lookup_values fvl12

Line 158914: FROM xla_events_gt xet

158910: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
158911: , l2.DISTRIBUTION_IDENTIFIER source_11
158912: , l2.ENTERED_AMOUNT source_18
158913: , l2.ACCOUNTED_AMOUNT source_22
158914: FROM xla_events_gt xet
158915: , CST_XLA_RCV_LINES_V l2
158916: WHERE xet.event_id between x_first_event_id and x_last_event_id
158917: and xet.event_date between p_pad_start_date and p_pad_end_date
158918: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 159724: FROM xla_events_gt xet

159720: WHEN 3 THEN fvl38.meaning
159721:
159722: ELSE null
159723: END source_meaning
159724: FROM xla_events_gt xet
159725: , CST_XLA_INV_HEADERS_V h1
159726: , fnd_lookup_values fvl12
159727: , fnd_lookup_values fvl35
159728: , fnd_lookup_values fvl38

Line 159877: FROM xla_events_gt xet

159873:
159874: ELSE null
159875: END source_value
159876: , null source_meaning
159877: FROM xla_events_gt xet
159878: , CST_XLA_INV_LINES_V l2
159879: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
159880: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
159881: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 160082: FROM xla_events_gt xet

160078: , h1.TRANSACTION_ACTION_ID source_35
160079: , fvl35.meaning source_35_meaning
160080: , h1.TRANSFER_TO_GL_INDICATOR source_38
160081: , fvl38.meaning source_38_meaning
160082: FROM xla_events_gt xet
160083: , CST_XLA_INV_HEADERS_V h1
160084: , fnd_lookup_values fvl12
160085: , fnd_lookup_values fvl35
160086: , fnd_lookup_values fvl38

Line 160146: FROM xla_events_gt xet

160142: , l2.CURRENCY_CONVERSION_RATE source_20
160143: , l2.CURRENCY_CONVERSION_TYPE source_21
160144: , l2.ACCOUNTED_AMOUNT source_22
160145: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
160146: FROM xla_events_gt xet
160147: , CST_XLA_INV_LINES_V l2
160148: WHERE xet.event_id between x_first_event_id and x_last_event_id
160149: and xet.event_date between p_pad_start_date and p_pad_end_date
160150: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 161041: FROM xla_events_gt xet

161037: WHEN 2 THEN fvl38.meaning
161038:
161039: ELSE null
161040: END source_meaning
161041: FROM xla_events_gt xet
161042: , CST_XLA_INV_HEADERS_V h1
161043: , fnd_lookup_values fvl12
161044: , fnd_lookup_values fvl38
161045: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 161189: FROM xla_events_gt xet

161185:
161186: ELSE null
161187: END source_value
161188: , null source_meaning
161189: FROM xla_events_gt xet
161190: , CST_XLA_INV_LINES_V l2
161191: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
161192: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
161193: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 161389: FROM xla_events_gt xet

161385: , h1.DISTRIBUTION_TYPE source_12
161386: , fvl12.meaning source_12_meaning
161387: , h1.TRANSFER_TO_GL_INDICATOR source_38
161388: , fvl38.meaning source_38_meaning
161389: FROM xla_events_gt xet
161390: , CST_XLA_INV_HEADERS_V h1
161391: , fnd_lookup_values fvl12
161392: , fnd_lookup_values fvl38
161393: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 161448: FROM xla_events_gt xet

161444: , l2.CURRENCY_CONVERSION_RATE source_20
161445: , l2.CURRENCY_CONVERSION_TYPE source_21
161446: , l2.ACCOUNTED_AMOUNT source_22
161447: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
161448: FROM xla_events_gt xet
161449: , CST_XLA_INV_LINES_V l2
161450: WHERE xet.event_id between x_first_event_id and x_last_event_id
161451: and xet.event_date between p_pad_start_date and p_pad_end_date
161452: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 162292: FROM xla_events_gt xet

162288: WHEN 5 THEN fvl38.meaning
162289:
162290: ELSE null
162291: END source_meaning
162292: FROM xla_events_gt xet
162293: , CST_XLA_WIP_HEADERS_V h1
162294: , fnd_lookup_values fvl12
162295: , fnd_lookup_values fvl38
162296: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

Line 162420: FROM xla_events_gt xet

162416:
162417: ELSE null
162418: END source_value
162419: , null source_meaning
162420: FROM xla_events_gt xet
162421: , CST_XLA_WIP_LINES_V l2
162422: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
162423: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
162424: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 162621: FROM xla_events_gt xet

162617: , h1.CURRENCY_CONVERSION_DATE source_19
162618: , h1.CURRENCY_CONVERSION_RATE source_20
162619: , h1.TRANSFER_TO_GL_INDICATOR source_38
162620: , fvl38.meaning source_38_meaning
162621: FROM xla_events_gt xet
162622: , CST_XLA_WIP_HEADERS_V h1
162623: , fnd_lookup_values fvl12
162624: , fnd_lookup_values fvl38
162625: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 162676: FROM xla_events_gt xet

162672: , l2.DISTRIBUTION_IDENTIFIER source_11
162673: , l2.ENTERED_AMOUNT source_18
162674: , l2.ACCOUNTED_AMOUNT source_22
162675: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
162676: FROM xla_events_gt xet
162677: , CST_XLA_WIP_LINES_V l2
162678: WHERE xet.event_id between x_first_event_id and x_last_event_id
162679: and xet.event_date between p_pad_start_date and p_pad_end_date
162680: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 163658: FROM xla_events_gt xet

163654: WHEN 16 THEN fvl38.meaning
163655:
163656: ELSE null
163657: END source_meaning
163658: FROM xla_events_gt xet
163659: , CST_XLA_RCV_HEADERS_V h1
163660: , CST_XLA_RCV_REF_V h3
163661: , PO_DISTS_REF_V h4
163662: , PO_HEADERS_REF_V h5

Line 163790: FROM xla_events_gt xet

163786:
163787: ELSE null
163788: END source_value
163789: , null source_meaning
163790: FROM xla_events_gt xet
163791: , CST_XLA_RCV_LINES_V l2
163792: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
163793: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
163794: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 164024: FROM xla_events_gt xet

164020: , h1.CURRENCY_CONVERSION_TYPE source_21
164021: , h5.PURCH_ENCUMBRANCE_TYPE_ID source_23
164022: , h1.TRANSFER_TO_GL_INDICATOR source_38
164023: , fvl38.meaning source_38_meaning
164024: FROM xla_events_gt xet
164025: , CST_XLA_RCV_HEADERS_V h1
164026: , CST_XLA_RCV_REF_V h3
164027: , PO_DISTS_REF_V h4
164028: , PO_HEADERS_REF_V h5

Line 164083: FROM xla_events_gt xet

164079: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
164080: , l2.DISTRIBUTION_IDENTIFIER source_11
164081: , l2.ENTERED_AMOUNT source_18
164082: , l2.ACCOUNTED_AMOUNT source_22
164083: FROM xla_events_gt xet
164084: , CST_XLA_RCV_LINES_V l2
164085: WHERE xet.event_id between x_first_event_id and x_last_event_id
164086: and xet.event_date between p_pad_start_date and p_pad_end_date
164087: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 165025: FROM xla_events_gt xet

165021: WHEN 12 THEN fvl38.meaning
165022:
165023: ELSE null
165024: END source_meaning
165025: FROM xla_events_gt xet
165026: , CST_XLA_INV_HEADERS_V h1
165027: , CST_XLA_INV_REF_V h3
165028: , PO_DISTS_REF_V h4
165029: , PO_HEADERS_REF_V h5

Line 165177: FROM xla_events_gt xet

165173:
165174: ELSE null
165175: END source_value
165176: , null source_meaning
165177: FROM xla_events_gt xet
165178: , CST_XLA_INV_LINES_V l2
165179: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
165180: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
165181: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 165407: FROM xla_events_gt xet

165403: , h6.CST_ENCUM_UPG_OPTION source_27
165404: , h3.TXN_PO_DISTRIBUTION_ID source_28
165405: , h1.TRANSFER_TO_GL_INDICATOR source_38
165406: , fvl38.meaning source_38_meaning
165407: FROM xla_events_gt xet
165408: , CST_XLA_INV_HEADERS_V h1
165409: , CST_XLA_INV_REF_V h3
165410: , PO_DISTS_REF_V h4
165411: , PO_HEADERS_REF_V h5

Line 165470: FROM xla_events_gt xet

165466: , l2.CURRENCY_CONVERSION_RATE source_20
165467: , l2.CURRENCY_CONVERSION_TYPE source_21
165468: , l2.ACCOUNTED_AMOUNT source_22
165469: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
165470: FROM xla_events_gt xet
165471: , CST_XLA_INV_LINES_V l2
165472: WHERE xet.event_id between x_first_event_id and x_last_event_id
165473: and xet.event_date between p_pad_start_date and p_pad_end_date
165474: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 166566: FROM xla_events_gt xet

166562: WHEN 6 THEN fvl38.meaning
166563:
166564: ELSE null
166565: END source_meaning
166566: FROM xla_events_gt xet
166567: , CST_XLA_RCV_HEADERS_V h1
166568: , fnd_lookup_values fvl12
166569: , fnd_lookup_values fvl38
166570: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

Line 166694: FROM xla_events_gt xet

166690:
166691: ELSE null
166692: END source_value
166693: , null source_meaning
166694: FROM xla_events_gt xet
166695: , CST_XLA_RCV_LINES_V l2
166696: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
166697: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
166698: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 166898: FROM xla_events_gt xet

166894: , h1.CURRENCY_CONVERSION_RATE source_20
166895: , h1.CURRENCY_CONVERSION_TYPE source_21
166896: , h1.TRANSFER_TO_GL_INDICATOR source_38
166897: , fvl38.meaning source_38_meaning
166898: FROM xla_events_gt xet
166899: , CST_XLA_RCV_HEADERS_V h1
166900: , fnd_lookup_values fvl12
166901: , fnd_lookup_values fvl38
166902: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 166953: FROM xla_events_gt xet

166949: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
166950: , l2.DISTRIBUTION_IDENTIFIER source_11
166951: , l2.ENTERED_AMOUNT source_18
166952: , l2.ACCOUNTED_AMOUNT source_22
166953: FROM xla_events_gt xet
166954: , CST_XLA_RCV_LINES_V l2
166955: WHERE xet.event_id between x_first_event_id and x_last_event_id
166956: and xet.event_date between p_pad_start_date and p_pad_end_date
166957: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 167888: FROM xla_events_gt xet

167884: WHEN 5 THEN fvl38.meaning
167885:
167886: ELSE null
167887: END source_meaning
167888: FROM xla_events_gt xet
167889: , CST_XLA_RCV_HEADERS_V h1
167890: , fnd_lookup_values fvl12
167891: , fnd_lookup_values fvl38
167892: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)

Line 168016: FROM xla_events_gt xet

168012:
168013: ELSE null
168014: END source_value
168015: , null source_meaning
168016: FROM xla_events_gt xet
168017: , CST_XLA_RCV_LINES_V l2
168018: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
168019: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
168020: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 168217: FROM xla_events_gt xet

168213: , h1.CURRENCY_CONVERSION_DATE source_19
168214: , h1.CURRENCY_CONVERSION_RATE source_20
168215: , h1.TRANSFER_TO_GL_INDICATOR source_38
168216: , fvl38.meaning source_38_meaning
168217: FROM xla_events_gt xet
168218: , CST_XLA_RCV_HEADERS_V h1
168219: , fnd_lookup_values fvl12
168220: , fnd_lookup_values fvl38
168221: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 168272: FROM xla_events_gt xet

168268: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
168269: , l2.DISTRIBUTION_IDENTIFIER source_11
168270: , l2.ENTERED_AMOUNT source_18
168271: , l2.ACCOUNTED_AMOUNT source_22
168272: FROM xla_events_gt xet
168273: , CST_XLA_RCV_LINES_V l2
168274: WHERE xet.event_id between x_first_event_id and x_last_event_id
168275: and xet.event_date between p_pad_start_date and p_pad_end_date
168276: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 169120: FROM xla_events_gt xet

169116: WHEN 6 THEN fvl38.meaning
169117:
169118: ELSE null
169119: END source_meaning
169120: FROM xla_events_gt xet
169121: , CST_XLA_RCV_HEADERS_V h1
169122: , fnd_lookup_values fvl12
169123: , fnd_lookup_values fvl38
169124: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

Line 169248: FROM xla_events_gt xet

169244:
169245: ELSE null
169246: END source_value
169247: , null source_meaning
169248: FROM xla_events_gt xet
169249: , CST_XLA_RCV_LINES_V l2
169250: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
169251: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
169252: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 169452: FROM xla_events_gt xet

169448: , h1.CURRENCY_CONVERSION_RATE source_20
169449: , h1.CURRENCY_CONVERSION_TYPE source_21
169450: , h1.TRANSFER_TO_GL_INDICATOR source_38
169451: , fvl38.meaning source_38_meaning
169452: FROM xla_events_gt xet
169453: , CST_XLA_RCV_HEADERS_V h1
169454: , fnd_lookup_values fvl12
169455: , fnd_lookup_values fvl38
169456: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 169507: FROM xla_events_gt xet

169503: , l2.RCV_ACCOUNTING_LINE_TYPE source_5
169504: , l2.DISTRIBUTION_IDENTIFIER source_11
169505: , l2.ENTERED_AMOUNT source_18
169506: , l2.ACCOUNTED_AMOUNT source_22
169507: FROM xla_events_gt xet
169508: , CST_XLA_RCV_LINES_V l2
169509: WHERE xet.event_id between x_first_event_id and x_last_event_id
169510: and xet.event_date between p_pad_start_date and p_pad_end_date
169511: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 170369: FROM xla_events_gt xet

170365: WHEN 2 THEN fvl38.meaning
170366:
170367: ELSE null
170368: END source_meaning
170369: FROM xla_events_gt xet
170370: , CST_XLA_INV_HEADERS_V h1
170371: , fnd_lookup_values fvl12
170372: , fnd_lookup_values fvl38
170373: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 170517: FROM xla_events_gt xet

170513:
170514: ELSE null
170515: END source_value
170516: , null source_meaning
170517: FROM xla_events_gt xet
170518: , CST_XLA_INV_LINES_V l2
170519: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
170520: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
170521: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 170717: FROM xla_events_gt xet

170713: , h1.DISTRIBUTION_TYPE source_12
170714: , fvl12.meaning source_12_meaning
170715: , h1.TRANSFER_TO_GL_INDICATOR source_38
170716: , fvl38.meaning source_38_meaning
170717: FROM xla_events_gt xet
170718: , CST_XLA_INV_HEADERS_V h1
170719: , fnd_lookup_values fvl12
170720: , fnd_lookup_values fvl38
170721: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 170776: FROM xla_events_gt xet

170772: , l2.CURRENCY_CONVERSION_RATE source_20
170773: , l2.CURRENCY_CONVERSION_TYPE source_21
170774: , l2.ACCOUNTED_AMOUNT source_22
170775: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
170776: FROM xla_events_gt xet
170777: , CST_XLA_INV_LINES_V l2
170778: WHERE xet.event_id between x_first_event_id and x_last_event_id
170779: and xet.event_date between p_pad_start_date and p_pad_end_date
170780: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 171663: FROM xla_events_gt xet

171659: WHEN 2 THEN fvl38.meaning
171660:
171661: ELSE null
171662: END source_meaning
171663: FROM xla_events_gt xet
171664: , CST_XLA_INV_HEADERS_V h1
171665: , fnd_lookup_values fvl12
171666: , fnd_lookup_values fvl38
171667: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 171810: FROM xla_events_gt xet

171806:
171807: ELSE null
171808: END source_value
171809: , null source_meaning
171810: FROM xla_events_gt xet
171811: , CST_XLA_INV_LINES_V l2
171812: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
171813: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
171814: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 172011: FROM xla_events_gt xet

172007: , h1.DISTRIBUTION_TYPE source_12
172008: , fvl12.meaning source_12_meaning
172009: , h1.TRANSFER_TO_GL_INDICATOR source_38
172010: , fvl38.meaning source_38_meaning
172011: FROM xla_events_gt xet
172012: , CST_XLA_INV_HEADERS_V h1
172013: , fnd_lookup_values fvl12
172014: , fnd_lookup_values fvl38
172015: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 172070: FROM xla_events_gt xet

172066: , l2.CURRENCY_CONVERSION_RATE source_20
172067: , l2.CURRENCY_CONVERSION_TYPE source_21
172068: , l2.ACCOUNTED_AMOUNT source_22
172069: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
172070: FROM xla_events_gt xet
172071: , CST_XLA_INV_LINES_V l2
172072: WHERE xet.event_id between x_first_event_id and x_last_event_id
172073: and xet.event_date between p_pad_start_date and p_pad_end_date
172074: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 172957: FROM xla_events_gt xet

172953: WHEN 2 THEN fvl38.meaning
172954:
172955: ELSE null
172956: END source_meaning
172957: FROM xla_events_gt xet
172958: , CST_XLA_INV_HEADERS_V h1
172959: , fnd_lookup_values fvl12
172960: , fnd_lookup_values fvl38
172961: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 173104: FROM xla_events_gt xet

173100:
173101: ELSE null
173102: END source_value
173103: , null source_meaning
173104: FROM xla_events_gt xet
173105: , CST_XLA_INV_LINES_V l2
173106: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
173107: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
173108: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 173305: FROM xla_events_gt xet

173301: , h1.DISTRIBUTION_TYPE source_12
173302: , fvl12.meaning source_12_meaning
173303: , h1.TRANSFER_TO_GL_INDICATOR source_38
173304: , fvl38.meaning source_38_meaning
173305: FROM xla_events_gt xet
173306: , CST_XLA_INV_HEADERS_V h1
173307: , fnd_lookup_values fvl12
173308: , fnd_lookup_values fvl38
173309: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 173364: FROM xla_events_gt xet

173360: , l2.CURRENCY_CONVERSION_RATE source_20
173361: , l2.CURRENCY_CONVERSION_TYPE source_21
173362: , l2.ACCOUNTED_AMOUNT source_22
173363: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
173364: FROM xla_events_gt xet
173365: , CST_XLA_INV_LINES_V l2
173366: WHERE xet.event_id between x_first_event_id and x_last_event_id
173367: and xet.event_date between p_pad_start_date and p_pad_end_date
173368: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 174193: FROM xla_events_gt xet

174189: WHEN 2 THEN fvl38.meaning
174190:
174191: ELSE null
174192: END source_meaning
174193: FROM xla_events_gt xet
174194: , CST_XLA_INV_HEADERS_V h1
174195: , fnd_lookup_values fvl12
174196: , fnd_lookup_values fvl38
174197: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 174340: FROM xla_events_gt xet

174336:
174337: ELSE null
174338: END source_value
174339: , null source_meaning
174340: FROM xla_events_gt xet
174341: , CST_XLA_INV_LINES_V l2
174342: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
174343: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
174344: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 174541: FROM xla_events_gt xet

174537: , h1.DISTRIBUTION_TYPE source_12
174538: , fvl12.meaning source_12_meaning
174539: , h1.TRANSFER_TO_GL_INDICATOR source_38
174540: , fvl38.meaning source_38_meaning
174541: FROM xla_events_gt xet
174542: , CST_XLA_INV_HEADERS_V h1
174543: , fnd_lookup_values fvl12
174544: , fnd_lookup_values fvl38
174545: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 174600: FROM xla_events_gt xet

174596: , l2.CURRENCY_CONVERSION_RATE source_20
174597: , l2.CURRENCY_CONVERSION_TYPE source_21
174598: , l2.ACCOUNTED_AMOUNT source_22
174599: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
174600: FROM xla_events_gt xet
174601: , CST_XLA_INV_LINES_V l2
174602: WHERE xet.event_id between x_first_event_id and x_last_event_id
174603: and xet.event_date between p_pad_start_date and p_pad_end_date
174604: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 175603: FROM xla_events_gt xet

175599: WHEN 2 THEN fvl38.meaning
175600:
175601: ELSE null
175602: END source_meaning
175603: FROM xla_events_gt xet
175604: , CST_XLA_INV_HEADERS_V h1
175605: , fnd_lookup_values fvl12
175606: , fnd_lookup_values fvl38
175607: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 175750: FROM xla_events_gt xet

175746:
175747: ELSE null
175748: END source_value
175749: , null source_meaning
175750: FROM xla_events_gt xet
175751: , CST_XLA_INV_LINES_V l2
175752: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
175753: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
175754: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 175951: FROM xla_events_gt xet

175947: , h1.DISTRIBUTION_TYPE source_12
175948: , fvl12.meaning source_12_meaning
175949: , h1.TRANSFER_TO_GL_INDICATOR source_38
175950: , fvl38.meaning source_38_meaning
175951: FROM xla_events_gt xet
175952: , CST_XLA_INV_HEADERS_V h1
175953: , fnd_lookup_values fvl12
175954: , fnd_lookup_values fvl38
175955: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 176010: FROM xla_events_gt xet

176006: , l2.CURRENCY_CONVERSION_RATE source_20
176007: , l2.CURRENCY_CONVERSION_TYPE source_21
176008: , l2.ACCOUNTED_AMOUNT source_22
176009: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
176010: FROM xla_events_gt xet
176011: , CST_XLA_INV_LINES_V l2
176012: WHERE xet.event_id between x_first_event_id and x_last_event_id
176013: and xet.event_date between p_pad_start_date and p_pad_end_date
176014: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 177013: FROM xla_events_gt xet

177009: WHEN 2 THEN fvl38.meaning
177010:
177011: ELSE null
177012: END source_meaning
177013: FROM xla_events_gt xet
177014: , CST_XLA_INV_HEADERS_V h1
177015: , fnd_lookup_values fvl12
177016: , fnd_lookup_values fvl38
177017: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 177160: FROM xla_events_gt xet

177156:
177157: ELSE null
177158: END source_value
177159: , null source_meaning
177160: FROM xla_events_gt xet
177161: , CST_XLA_INV_LINES_V l2
177162: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
177163: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
177164: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 177361: FROM xla_events_gt xet

177357: , h1.DISTRIBUTION_TYPE source_12
177358: , fvl12.meaning source_12_meaning
177359: , h1.TRANSFER_TO_GL_INDICATOR source_38
177360: , fvl38.meaning source_38_meaning
177361: FROM xla_events_gt xet
177362: , CST_XLA_INV_HEADERS_V h1
177363: , fnd_lookup_values fvl12
177364: , fnd_lookup_values fvl38
177365: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 177420: FROM xla_events_gt xet

177416: , l2.CURRENCY_CONVERSION_RATE source_20
177417: , l2.CURRENCY_CONVERSION_TYPE source_21
177418: , l2.ACCOUNTED_AMOUNT source_22
177419: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
177420: FROM xla_events_gt xet
177421: , CST_XLA_INV_LINES_V l2
177422: WHERE xet.event_id between x_first_event_id and x_last_event_id
177423: and xet.event_date between p_pad_start_date and p_pad_end_date
177424: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 178423: FROM xla_events_gt xet

178419: WHEN 2 THEN fvl38.meaning
178420:
178421: ELSE null
178422: END source_meaning
178423: FROM xla_events_gt xet
178424: , CST_XLA_INV_HEADERS_V h1
178425: , fnd_lookup_values fvl12
178426: , fnd_lookup_values fvl38
178427: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 178570: FROM xla_events_gt xet

178566:
178567: ELSE null
178568: END source_value
178569: , null source_meaning
178570: FROM xla_events_gt xet
178571: , CST_XLA_INV_LINES_V l2
178572: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
178573: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
178574: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 178771: FROM xla_events_gt xet

178767: , h1.DISTRIBUTION_TYPE source_12
178768: , fvl12.meaning source_12_meaning
178769: , h1.TRANSFER_TO_GL_INDICATOR source_38
178770: , fvl38.meaning source_38_meaning
178771: FROM xla_events_gt xet
178772: , CST_XLA_INV_HEADERS_V h1
178773: , fnd_lookup_values fvl12
178774: , fnd_lookup_values fvl38
178775: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 178830: FROM xla_events_gt xet

178826: , l2.CURRENCY_CONVERSION_RATE source_20
178827: , l2.CURRENCY_CONVERSION_TYPE source_21
178828: , l2.ACCOUNTED_AMOUNT source_22
178829: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
178830: FROM xla_events_gt xet
178831: , CST_XLA_INV_LINES_V l2
178832: WHERE xet.event_id between x_first_event_id and x_last_event_id
178833: and xet.event_date between p_pad_start_date and p_pad_end_date
178834: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 179833: FROM xla_events_gt xet

179829: WHEN 2 THEN fvl38.meaning
179830:
179831: ELSE null
179832: END source_meaning
179833: FROM xla_events_gt xet
179834: , CST_XLA_INV_HEADERS_V h1
179835: , fnd_lookup_values fvl12
179836: , fnd_lookup_values fvl38
179837: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 179980: FROM xla_events_gt xet

179976:
179977: ELSE null
179978: END source_value
179979: , null source_meaning
179980: FROM xla_events_gt xet
179981: , CST_XLA_INV_LINES_V l2
179982: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
179983: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
179984: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 180181: FROM xla_events_gt xet

180177: , h1.DISTRIBUTION_TYPE source_12
180178: , fvl12.meaning source_12_meaning
180179: , h1.TRANSFER_TO_GL_INDICATOR source_38
180180: , fvl38.meaning source_38_meaning
180181: FROM xla_events_gt xet
180182: , CST_XLA_INV_HEADERS_V h1
180183: , fnd_lookup_values fvl12
180184: , fnd_lookup_values fvl38
180185: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 180240: FROM xla_events_gt xet

180236: , l2.CURRENCY_CONVERSION_RATE source_20
180237: , l2.CURRENCY_CONVERSION_TYPE source_21
180238: , l2.ACCOUNTED_AMOUNT source_22
180239: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
180240: FROM xla_events_gt xet
180241: , CST_XLA_INV_LINES_V l2
180242: WHERE xet.event_id between x_first_event_id and x_last_event_id
180243: and xet.event_date between p_pad_start_date and p_pad_end_date
180244: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 181243: FROM xla_events_gt xet

181239: WHEN 2 THEN fvl38.meaning
181240:
181241: ELSE null
181242: END source_meaning
181243: FROM xla_events_gt xet
181244: , CST_XLA_INV_HEADERS_V h1
181245: , fnd_lookup_values fvl12
181246: , fnd_lookup_values fvl38
181247: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 181390: FROM xla_events_gt xet

181386:
181387: ELSE null
181388: END source_value
181389: , null source_meaning
181390: FROM xla_events_gt xet
181391: , CST_XLA_INV_LINES_V l2
181392: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
181393: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
181394: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 181591: FROM xla_events_gt xet

181587: , h1.DISTRIBUTION_TYPE source_12
181588: , fvl12.meaning source_12_meaning
181589: , h1.TRANSFER_TO_GL_INDICATOR source_38
181590: , fvl38.meaning source_38_meaning
181591: FROM xla_events_gt xet
181592: , CST_XLA_INV_HEADERS_V h1
181593: , fnd_lookup_values fvl12
181594: , fnd_lookup_values fvl38
181595: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 181650: FROM xla_events_gt xet

181646: , l2.CURRENCY_CONVERSION_RATE source_20
181647: , l2.CURRENCY_CONVERSION_TYPE source_21
181648: , l2.ACCOUNTED_AMOUNT source_22
181649: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
181650: FROM xla_events_gt xet
181651: , CST_XLA_INV_LINES_V l2
181652: WHERE xet.event_id between x_first_event_id and x_last_event_id
181653: and xet.event_date between p_pad_start_date and p_pad_end_date
181654: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 182653: FROM xla_events_gt xet

182649: WHEN 2 THEN fvl38.meaning
182650:
182651: ELSE null
182652: END source_meaning
182653: FROM xla_events_gt xet
182654: , CST_XLA_INV_HEADERS_V h1
182655: , fnd_lookup_values fvl12
182656: , fnd_lookup_values fvl38
182657: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 182800: FROM xla_events_gt xet

182796:
182797: ELSE null
182798: END source_value
182799: , null source_meaning
182800: FROM xla_events_gt xet
182801: , CST_XLA_INV_LINES_V l2
182802: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
182803: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
182804: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 183001: FROM xla_events_gt xet

182997: , h1.DISTRIBUTION_TYPE source_12
182998: , fvl12.meaning source_12_meaning
182999: , h1.TRANSFER_TO_GL_INDICATOR source_38
183000: , fvl38.meaning source_38_meaning
183001: FROM xla_events_gt xet
183002: , CST_XLA_INV_HEADERS_V h1
183003: , fnd_lookup_values fvl12
183004: , fnd_lookup_values fvl38
183005: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 183060: FROM xla_events_gt xet

183056: , l2.CURRENCY_CONVERSION_RATE source_20
183057: , l2.CURRENCY_CONVERSION_TYPE source_21
183058: , l2.ACCOUNTED_AMOUNT source_22
183059: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
183060: FROM xla_events_gt xet
183061: , CST_XLA_INV_LINES_V l2
183062: WHERE xet.event_id between x_first_event_id and x_last_event_id
183063: and xet.event_date between p_pad_start_date and p_pad_end_date
183064: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 183889: FROM xla_events_gt xet

183885: WHEN 2 THEN fvl38.meaning
183886:
183887: ELSE null
183888: END source_meaning
183889: FROM xla_events_gt xet
183890: , CST_XLA_INV_HEADERS_V h1
183891: , fnd_lookup_values fvl12
183892: , fnd_lookup_values fvl38
183893: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 184036: FROM xla_events_gt xet

184032:
184033: ELSE null
184034: END source_value
184035: , null source_meaning
184036: FROM xla_events_gt xet
184037: , CST_XLA_INV_LINES_V l2
184038: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
184039: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
184040: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 184237: FROM xla_events_gt xet

184233: , h1.DISTRIBUTION_TYPE source_12
184234: , fvl12.meaning source_12_meaning
184235: , h1.TRANSFER_TO_GL_INDICATOR source_38
184236: , fvl38.meaning source_38_meaning
184237: FROM xla_events_gt xet
184238: , CST_XLA_INV_HEADERS_V h1
184239: , fnd_lookup_values fvl12
184240: , fnd_lookup_values fvl38
184241: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 184296: FROM xla_events_gt xet

184292: , l2.CURRENCY_CONVERSION_RATE source_20
184293: , l2.CURRENCY_CONVERSION_TYPE source_21
184294: , l2.ACCOUNTED_AMOUNT source_22
184295: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
184296: FROM xla_events_gt xet
184297: , CST_XLA_INV_LINES_V l2
184298: WHERE xet.event_id between x_first_event_id and x_last_event_id
184299: and xet.event_date between p_pad_start_date and p_pad_end_date
184300: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 185299: FROM xla_events_gt xet

185295: WHEN 2 THEN fvl38.meaning
185296:
185297: ELSE null
185298: END source_meaning
185299: FROM xla_events_gt xet
185300: , CST_XLA_INV_HEADERS_V h1
185301: , fnd_lookup_values fvl12
185302: , fnd_lookup_values fvl38
185303: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 185446: FROM xla_events_gt xet

185442:
185443: ELSE null
185444: END source_value
185445: , null source_meaning
185446: FROM xla_events_gt xet
185447: , CST_XLA_INV_LINES_V l2
185448: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
185449: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
185450: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 185647: FROM xla_events_gt xet

185643: , h1.DISTRIBUTION_TYPE source_12
185644: , fvl12.meaning source_12_meaning
185645: , h1.TRANSFER_TO_GL_INDICATOR source_38
185646: , fvl38.meaning source_38_meaning
185647: FROM xla_events_gt xet
185648: , CST_XLA_INV_HEADERS_V h1
185649: , fnd_lookup_values fvl12
185650: , fnd_lookup_values fvl38
185651: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 185706: FROM xla_events_gt xet

185702: , l2.CURRENCY_CONVERSION_RATE source_20
185703: , l2.CURRENCY_CONVERSION_TYPE source_21
185704: , l2.ACCOUNTED_AMOUNT source_22
185705: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
185706: FROM xla_events_gt xet
185707: , CST_XLA_INV_LINES_V l2
185708: WHERE xet.event_id between x_first_event_id and x_last_event_id
185709: and xet.event_date between p_pad_start_date and p_pad_end_date
185710: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 186709: FROM xla_events_gt xet

186705: WHEN 2 THEN fvl38.meaning
186706:
186707: ELSE null
186708: END source_meaning
186709: FROM xla_events_gt xet
186710: , CST_XLA_INV_HEADERS_V h1
186711: , fnd_lookup_values fvl12
186712: , fnd_lookup_values fvl38
186713: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 186856: FROM xla_events_gt xet

186852:
186853: ELSE null
186854: END source_value
186855: , null source_meaning
186856: FROM xla_events_gt xet
186857: , CST_XLA_INV_LINES_V l2
186858: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
186859: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
186860: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 187057: FROM xla_events_gt xet

187053: , h1.DISTRIBUTION_TYPE source_12
187054: , fvl12.meaning source_12_meaning
187055: , h1.TRANSFER_TO_GL_INDICATOR source_38
187056: , fvl38.meaning source_38_meaning
187057: FROM xla_events_gt xet
187058: , CST_XLA_INV_HEADERS_V h1
187059: , fnd_lookup_values fvl12
187060: , fnd_lookup_values fvl38
187061: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 187116: FROM xla_events_gt xet

187112: , l2.CURRENCY_CONVERSION_RATE source_20
187113: , l2.CURRENCY_CONVERSION_TYPE source_21
187114: , l2.ACCOUNTED_AMOUNT source_22
187115: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
187116: FROM xla_events_gt xet
187117: , CST_XLA_INV_LINES_V l2
187118: WHERE xet.event_id between x_first_event_id and x_last_event_id
187119: and xet.event_date between p_pad_start_date and p_pad_end_date
187120: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 188032: FROM xla_events_gt xet

188028: WHEN 2 THEN fvl38.meaning
188029:
188030: ELSE null
188031: END source_meaning
188032: FROM xla_events_gt xet
188033: , CST_XLA_INV_HEADERS_V h1
188034: , fnd_lookup_values fvl12
188035: , fnd_lookup_values fvl38
188036: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 188179: FROM xla_events_gt xet

188175:
188176: ELSE null
188177: END source_value
188178: , null source_meaning
188179: FROM xla_events_gt xet
188180: , CST_XLA_INV_LINES_V l2
188181: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
188182: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
188183: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 188380: FROM xla_events_gt xet

188376: , h1.DISTRIBUTION_TYPE source_12
188377: , fvl12.meaning source_12_meaning
188378: , h1.TRANSFER_TO_GL_INDICATOR source_38
188379: , fvl38.meaning source_38_meaning
188380: FROM xla_events_gt xet
188381: , CST_XLA_INV_HEADERS_V h1
188382: , fnd_lookup_values fvl12
188383: , fnd_lookup_values fvl38
188384: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 188439: FROM xla_events_gt xet

188435: , l2.CURRENCY_CONVERSION_RATE source_20
188436: , l2.CURRENCY_CONVERSION_TYPE source_21
188437: , l2.ACCOUNTED_AMOUNT source_22
188438: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
188439: FROM xla_events_gt xet
188440: , CST_XLA_INV_LINES_V l2
188441: WHERE xet.event_id between x_first_event_id and x_last_event_id
188442: and xet.event_date between p_pad_start_date and p_pad_end_date
188443: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 189355: FROM xla_events_gt xet

189351: WHEN 2 THEN fvl38.meaning
189352:
189353: ELSE null
189354: END source_meaning
189355: FROM xla_events_gt xet
189356: , CST_XLA_INV_HEADERS_V h1
189357: , fnd_lookup_values fvl12
189358: , fnd_lookup_values fvl38
189359: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 189502: FROM xla_events_gt xet

189498:
189499: ELSE null
189500: END source_value
189501: , null source_meaning
189502: FROM xla_events_gt xet
189503: , CST_XLA_INV_LINES_V l2
189504: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
189505: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
189506: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 189703: FROM xla_events_gt xet

189699: , h1.DISTRIBUTION_TYPE source_12
189700: , fvl12.meaning source_12_meaning
189701: , h1.TRANSFER_TO_GL_INDICATOR source_38
189702: , fvl38.meaning source_38_meaning
189703: FROM xla_events_gt xet
189704: , CST_XLA_INV_HEADERS_V h1
189705: , fnd_lookup_values fvl12
189706: , fnd_lookup_values fvl38
189707: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 189762: FROM xla_events_gt xet

189758: , l2.CURRENCY_CONVERSION_RATE source_20
189759: , l2.CURRENCY_CONVERSION_TYPE source_21
189760: , l2.ACCOUNTED_AMOUNT source_22
189761: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
189762: FROM xla_events_gt xet
189763: , CST_XLA_INV_LINES_V l2
189764: WHERE xet.event_id between x_first_event_id and x_last_event_id
189765: and xet.event_date between p_pad_start_date and p_pad_end_date
189766: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 190620: FROM xla_events_gt xet

190616: WHEN 2 THEN fvl38.meaning
190617:
190618: ELSE null
190619: END source_meaning
190620: FROM xla_events_gt xet
190621: , CST_XLA_INV_HEADERS_V h1
190622: , fnd_lookup_values fvl12
190623: , fnd_lookup_values fvl38
190624: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 190767: FROM xla_events_gt xet

190763:
190764: ELSE null
190765: END source_value
190766: , null source_meaning
190767: FROM xla_events_gt xet
190768: , CST_XLA_INV_LINES_V l2
190769: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
190770: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
190771: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 190968: FROM xla_events_gt xet

190964: , h1.DISTRIBUTION_TYPE source_12
190965: , fvl12.meaning source_12_meaning
190966: , h1.TRANSFER_TO_GL_INDICATOR source_38
190967: , fvl38.meaning source_38_meaning
190968: FROM xla_events_gt xet
190969: , CST_XLA_INV_HEADERS_V h1
190970: , fnd_lookup_values fvl12
190971: , fnd_lookup_values fvl38
190972: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 191027: FROM xla_events_gt xet

191023: , l2.CURRENCY_CONVERSION_RATE source_20
191024: , l2.CURRENCY_CONVERSION_TYPE source_21
191025: , l2.ACCOUNTED_AMOUNT source_22
191026: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
191027: FROM xla_events_gt xet
191028: , CST_XLA_INV_LINES_V l2
191029: WHERE xet.event_id between x_first_event_id and x_last_event_id
191030: and xet.event_date between p_pad_start_date and p_pad_end_date
191031: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 191856: FROM xla_events_gt xet

191852: WHEN 2 THEN fvl38.meaning
191853:
191854: ELSE null
191855: END source_meaning
191856: FROM xla_events_gt xet
191857: , CST_XLA_INV_HEADERS_V h1
191858: , fnd_lookup_values fvl12
191859: , fnd_lookup_values fvl38
191860: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 192003: FROM xla_events_gt xet

191999:
192000: ELSE null
192001: END source_value
192002: , null source_meaning
192003: FROM xla_events_gt xet
192004: , CST_XLA_INV_LINES_V l2
192005: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
192006: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
192007: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 192204: FROM xla_events_gt xet

192200: , h1.DISTRIBUTION_TYPE source_12
192201: , fvl12.meaning source_12_meaning
192202: , h1.TRANSFER_TO_GL_INDICATOR source_38
192203: , fvl38.meaning source_38_meaning
192204: FROM xla_events_gt xet
192205: , CST_XLA_INV_HEADERS_V h1
192206: , fnd_lookup_values fvl12
192207: , fnd_lookup_values fvl38
192208: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 192263: FROM xla_events_gt xet

192259: , l2.CURRENCY_CONVERSION_RATE source_20
192260: , l2.CURRENCY_CONVERSION_TYPE source_21
192261: , l2.ACCOUNTED_AMOUNT source_22
192262: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
192263: FROM xla_events_gt xet
192264: , CST_XLA_INV_LINES_V l2
192265: WHERE xet.event_id between x_first_event_id and x_last_event_id
192266: and xet.event_date between p_pad_start_date and p_pad_end_date
192267: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 193092: FROM xla_events_gt xet

193088: WHEN 2 THEN fvl38.meaning
193089:
193090: ELSE null
193091: END source_meaning
193092: FROM xla_events_gt xet
193093: , CST_XLA_INV_HEADERS_V h1
193094: , fnd_lookup_values fvl12
193095: , fnd_lookup_values fvl38
193096: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 193239: FROM xla_events_gt xet

193235:
193236: ELSE null
193237: END source_value
193238: , null source_meaning
193239: FROM xla_events_gt xet
193240: , CST_XLA_INV_LINES_V l2
193241: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
193242: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
193243: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 193440: FROM xla_events_gt xet

193436: , h1.DISTRIBUTION_TYPE source_12
193437: , fvl12.meaning source_12_meaning
193438: , h1.TRANSFER_TO_GL_INDICATOR source_38
193439: , fvl38.meaning source_38_meaning
193440: FROM xla_events_gt xet
193441: , CST_XLA_INV_HEADERS_V h1
193442: , fnd_lookup_values fvl12
193443: , fnd_lookup_values fvl38
193444: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 193499: FROM xla_events_gt xet

193495: , l2.CURRENCY_CONVERSION_RATE source_20
193496: , l2.CURRENCY_CONVERSION_TYPE source_21
193497: , l2.ACCOUNTED_AMOUNT source_22
193498: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
193499: FROM xla_events_gt xet
193500: , CST_XLA_INV_LINES_V l2
193501: WHERE xet.event_id between x_first_event_id and x_last_event_id
193502: and xet.event_date between p_pad_start_date and p_pad_end_date
193503: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 194348: FROM xla_events_gt xet

194344: WHEN 6 THEN fvl38.meaning
194345:
194346: ELSE null
194347: END source_meaning
194348: FROM xla_events_gt xet
194349: , CST_XLA_WIP_HEADERS_V h1
194350: , fnd_lookup_values fvl12
194351: , fnd_lookup_values fvl38
194352: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

Line 194476: FROM xla_events_gt xet

194472:
194473: ELSE null
194474: END source_value
194475: , null source_meaning
194476: FROM xla_events_gt xet
194477: , CST_XLA_WIP_LINES_V l2
194478: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
194479: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
194480: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 194680: FROM xla_events_gt xet

194676: , h1.CURRENCY_CONVERSION_RATE source_20
194677: , h1.CURRENCY_CONVERSION_TYPE source_21
194678: , h1.TRANSFER_TO_GL_INDICATOR source_38
194679: , fvl38.meaning source_38_meaning
194680: FROM xla_events_gt xet
194681: , CST_XLA_WIP_HEADERS_V h1
194682: , fnd_lookup_values fvl12
194683: , fnd_lookup_values fvl38
194684: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 194735: FROM xla_events_gt xet

194731: , l2.DISTRIBUTION_IDENTIFIER source_11
194732: , l2.ENTERED_AMOUNT source_18
194733: , l2.ACCOUNTED_AMOUNT source_22
194734: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
194735: FROM xla_events_gt xet
194736: , CST_XLA_WIP_LINES_V l2
194737: WHERE xet.event_id between x_first_event_id and x_last_event_id
194738: and xet.event_date between p_pad_start_date and p_pad_end_date
194739: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 195559: FROM xla_events_gt xet

195555: WHEN 6 THEN fvl38.meaning
195556:
195557: ELSE null
195558: END source_meaning
195559: FROM xla_events_gt xet
195560: , CST_XLA_WIP_HEADERS_V h1
195561: , fnd_lookup_values fvl12
195562: , fnd_lookup_values fvl38
195563: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

Line 195687: FROM xla_events_gt xet

195683:
195684: ELSE null
195685: END source_value
195686: , null source_meaning
195687: FROM xla_events_gt xet
195688: , CST_XLA_WIP_LINES_V l2
195689: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
195690: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
195691: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 195891: FROM xla_events_gt xet

195887: , h1.CURRENCY_CONVERSION_RATE source_20
195888: , h1.CURRENCY_CONVERSION_TYPE source_21
195889: , h1.TRANSFER_TO_GL_INDICATOR source_38
195890: , fvl38.meaning source_38_meaning
195891: FROM xla_events_gt xet
195892: , CST_XLA_WIP_HEADERS_V h1
195893: , fnd_lookup_values fvl12
195894: , fnd_lookup_values fvl38
195895: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 195946: FROM xla_events_gt xet

195942: , l2.DISTRIBUTION_IDENTIFIER source_11
195943: , l2.ENTERED_AMOUNT source_18
195944: , l2.ACCOUNTED_AMOUNT source_22
195945: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
195946: FROM xla_events_gt xet
195947: , CST_XLA_WIP_LINES_V l2
195948: WHERE xet.event_id between x_first_event_id and x_last_event_id
195949: and xet.event_date between p_pad_start_date and p_pad_end_date
195950: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 196770: FROM xla_events_gt xet

196766: WHEN 6 THEN fvl38.meaning
196767:
196768: ELSE null
196769: END source_meaning
196770: FROM xla_events_gt xet
196771: , CST_XLA_WIP_HEADERS_V h1
196772: , fnd_lookup_values fvl12
196773: , fnd_lookup_values fvl38
196774: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)

Line 196898: FROM xla_events_gt xet

196894:
196895: ELSE null
196896: END source_value
196897: , null source_meaning
196898: FROM xla_events_gt xet
196899: , CST_XLA_WIP_LINES_V l2
196900: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
196901: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
196902: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 197102: FROM xla_events_gt xet

197098: , h1.CURRENCY_CONVERSION_RATE source_20
197099: , h1.CURRENCY_CONVERSION_TYPE source_21
197100: , h1.TRANSFER_TO_GL_INDICATOR source_38
197101: , fvl38.meaning source_38_meaning
197102: FROM xla_events_gt xet
197103: , CST_XLA_WIP_HEADERS_V h1
197104: , fnd_lookup_values fvl12
197105: , fnd_lookup_values fvl38
197106: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 197157: FROM xla_events_gt xet

197153: , l2.DISTRIBUTION_IDENTIFIER source_11
197154: , l2.ENTERED_AMOUNT source_18
197155: , l2.ACCOUNTED_AMOUNT source_22
197156: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
197157: FROM xla_events_gt xet
197158: , CST_XLA_WIP_LINES_V l2
197159: WHERE xet.event_id between x_first_event_id and x_last_event_id
197160: and xet.event_date between p_pad_start_date and p_pad_end_date
197161: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 197961: FROM xla_events_gt xet

197957: WHEN 2 THEN fvl38.meaning
197958:
197959: ELSE null
197960: END source_meaning
197961: FROM xla_events_gt xet
197962: , CST_XLA_INV_HEADERS_V h1
197963: , fnd_lookup_values fvl12
197964: , fnd_lookup_values fvl38
197965: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)

Line 198109: FROM xla_events_gt xet

198105:
198106: ELSE null
198107: END source_value
198108: , null source_meaning
198109: FROM xla_events_gt xet
198110: , CST_XLA_INV_LINES_V l2
198111: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
198112: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
198113: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 198309: FROM xla_events_gt xet

198305: , h1.DISTRIBUTION_TYPE source_12
198306: , fvl12.meaning source_12_meaning
198307: , h1.TRANSFER_TO_GL_INDICATOR source_38
198308: , fvl38.meaning source_38_meaning
198309: FROM xla_events_gt xet
198310: , CST_XLA_INV_HEADERS_V h1
198311: , fnd_lookup_values fvl12
198312: , fnd_lookup_values fvl38
198313: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 198368: FROM xla_events_gt xet

198364: , l2.CURRENCY_CONVERSION_RATE source_20
198365: , l2.CURRENCY_CONVERSION_TYPE source_21
198366: , l2.ACCOUNTED_AMOUNT source_22
198367: , l2.ACCOUNTING_LINE_TYPE_CODE source_24
198368: FROM xla_events_gt xet
198369: , CST_XLA_INV_LINES_V l2
198370: WHERE xet.event_id between x_first_event_id and x_last_event_id
198371: and xet.event_date between p_pad_start_date and p_pad_end_date
198372: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 200757: (p_msg => '# of events in xla_events_gt: '

200753: ,p_level => C_LEVEL_STATEMENT
200754: ,p_module => l_log_module);
200755:
200756: trace
200757: (p_msg => '# of events in xla_events_gt: '
200758: ||xla_context_pkg.get_event_count_context
200759: ,p_level => C_LEVEL_STATEMENT
200760: ,p_module => l_log_module);
200761: