[Home] [Help]
66603:
66604: ELSE null
66605: END source_value
66606: , null source_meaning
66607: FROM xla_events_gt xet
66608: , AR_ADJUSTMENTS_H_V h1
66609: , AR_BILL_TO_CUSTOMERS_S_V h2
66610: , AR_BILL_TO_SITE_USES_S_V h3
66611: , AR_RECEIVABLES_TRX_ACT_S_V h6
66754:
66755: ELSE null
66756: END source_value
66757: , null source_meaning
66758: FROM xla_events_gt xet
66759: , AR_DISTRIBUTIONS_BASE_V l4
66760: , AR_DISTRIBUTIONS_L_V l5
66761: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
66762: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66973: , h3.BILL_USES_SITE_USE_ID source_50
66974: , h7.XLA_PARTY_TYPE source_51
66975: , h1.ADJ_DOC_SEQUENCE_CATEGORY source_117
66976: , h1.ADJ_DOC_SEQUENCE_ID source_118
66977: FROM xla_events_gt xet
66978: , AR_ADJUSTMENTS_H_V h1
66979: , AR_BILL_TO_CUSTOMERS_S_V h2
66980: , AR_BILL_TO_SITE_USES_S_V h3
66981: , AR_RECEIVABLES_TRX_ACT_S_V h6
67031: , l4.DIST_CUR_CONVERSION_DATE source_45
67032: , l4.DIST_CUR_CONVERSION_RATE source_46
67033: , l4.DIST_CUR_CONVERSION_TYPE source_47
67034: , l4.DIST_TO_ACCTD_AMT source_48
67035: FROM xla_events_gt xet
67036: , AR_DISTRIBUTIONS_BASE_V l4
67037: , AR_DISTRIBUTIONS_L_V l5
67038: WHERE xet.event_id between x_first_event_id and x_last_event_id
67039: and xet.event_date between p_pad_start_date and p_pad_end_date
68069:
68070: ELSE null
68071: END source_value
68072: , null source_meaning
68073: FROM xla_events_gt xet
68074: , AR_DRAWEE_CUSTOMERS_H_V h3
68075: , AR_DRAWEE_SITE_USES_H_V h4
68076: , AR_SYSTEM_PARAM_H_V h5
68077: , AR_TRANSACTIONS_S_V h6
68218:
68219: ELSE null
68220: END source_value
68221: , null source_meaning
68222: FROM xla_events_gt xet
68223: , AR_DISTRIBUTIONS_BASE_V l1
68224: , AR_DISTRIBUTIONS_L_V l2
68225: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
68226: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68434: , h5.CODE_COMBINATION_ID_LOSS source_35
68435: , h6.XLA_PARTY_TYPE source_51
68436: , h3.DRAW_CUST_ACCOUNT_ID source_53
68437: , h4.DRAW_SITE_SITE_USE_ID source_54
68438: FROM xla_events_gt xet
68439: , AR_DRAWEE_CUSTOMERS_H_V h3
68440: , AR_DRAWEE_SITE_USES_H_V h4
68441: , AR_SYSTEM_PARAM_H_V h5
68442: , AR_TRANSACTIONS_S_V h6
68490: , l1.DIST_CUR_CONVERSION_DATE source_45
68491: , l1.DIST_CUR_CONVERSION_RATE source_46
68492: , l1.DIST_CUR_CONVERSION_TYPE source_47
68493: , l1.DIST_ACCTD_AMT source_52
68494: FROM xla_events_gt xet
68495: , AR_DISTRIBUTIONS_BASE_V l1
68496: , AR_DISTRIBUTIONS_L_V l2
68497: WHERE xet.event_id between x_first_event_id and x_last_event_id
68498: and xet.event_date between p_pad_start_date and p_pad_end_date
69466:
69467: ELSE null
69468: END source_value
69469: , null source_meaning
69470: FROM xla_events_gt xet
69471: , AR_BILL_TO_CUSTOMERS_S_V h1
69472: , AR_BILL_TO_SITE_USES_S_V h2
69473: , AR_TRANSACTIONS_S_V h5
69474: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69608:
69609: ELSE null
69610: END source_value
69611: , null source_meaning
69612: FROM xla_events_gt xet
69613: , AR_CUST_TRX_LINES_BASE_V l3
69614: , AR_CUST_TRX_LINES_L_V l4
69615: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69616: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69828: , h2.BILL_USES_SITE_USE_ID source_50
69829: , h5.XLA_PARTY_TYPE source_51
69830: , h5.TRX_INVOICE_CURRENCY_CODE source_59
69831: , h5.TRX_DOC_SEQUENCE_ID source_120
69832: FROM xla_events_gt xet
69833: , AR_BILL_TO_CUSTOMERS_S_V h1
69834: , AR_BILL_TO_SITE_USES_S_V h2
69835: , AR_TRANSACTIONS_S_V h5
69836: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69881: , l3.TRX_LINE_CUR_CONVERSION_DATE source_60
69882: , l3.TRX_LINE_CUR_CONVERSION_RATE source_61
69883: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
69884: , l3.TRX_LINE_ACCTD_AMT source_63
69885: FROM xla_events_gt xet
69886: , AR_CUST_TRX_LINES_BASE_V l3
69887: , AR_CUST_TRX_LINES_L_V l4
69888: WHERE xet.event_id between x_first_event_id and x_last_event_id
69889: and xet.event_date between p_pad_start_date and p_pad_end_date
70788: WHEN 17 THEN fvl124.meaning
70789:
70790: ELSE null
70791: END source_meaning
70792: FROM xla_events_gt xet
70793: , AR_BILL_TO_CUSTOMERS_S_V h1
70794: , AR_BILL_TO_SITE_USES_S_V h2
70795: , AR_REMIT_BANK_ACCT_H_V h3
70796: , AR_TRANSACTIONS_S_V h4
71011: WHEN 22 THEN fvl96.meaning
71012:
71013: ELSE null
71014: END source_meaning
71015: FROM xla_events_gt xet
71016: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71017: , fnd_lookup_values fvl13
71018: , fnd_lookup_values fvl77
71019: , fnd_lookup_values fvl78
71304: , h6.JLBR_EXCHG_LOSS_CCID source_122
71305: , h6.JLBR_GL_DATE source_123
71306: , h6.JLBR_TRANSFER_TO_GL_FLAG source_124
71307: , fvl124.meaning source_124_meaning
71308: FROM xla_events_gt xet
71309: , AR_BILL_TO_CUSTOMERS_S_V h1
71310: , AR_BILL_TO_SITE_USES_S_V h2
71311: , AR_REMIT_BANK_ACCT_H_V h3
71312: , AR_TRANSACTIONS_S_V h4
71383: , l5.JLBR_REVERSED_DIST_ID source_94
71384: , l5.JLBR_REVERSED_DIST_LINK_TYPE source_95
71385: , l5.JLBR_BANK_OCC_TYPE source_96
71386: , fvl96.meaning source_96_meaning
71387: FROM xla_events_gt xet
71388: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
71389: , fnd_lookup_values fvl13
71390: , fnd_lookup_values fvl77
71391: , fnd_lookup_values fvl78
72510:
72511: ELSE null
72512: END source_value
72513: , null source_meaning
72514: FROM xla_events_gt xet
72515: , AR_CM_BILL_SITE_USES_H_V h1
72516: , AR_CM_BILL_TO_CUST_H_V h2
72517: , AR_CREDIT_MEMO_H_V h5
72518: , AR_SYSTEM_PARAM_H_V h8
72699:
72700: ELSE null
72701: END source_value
72702: , null source_meaning
72703: FROM xla_events_gt xet
72704: , AR_CM_LINES_BASE_V l3
72705: , AR_CM_LINES_L_V l4
72706: , AR_DISTRIBUTIONS_L_V l6
72707: , AR_RECEIVABLES_TRX_ACT_S_V l7
72946: , h5.XLA_PARTY_TYPE source_51
72947: , h5.CM_INVOICE_CURRENCY_CODE source_66
72948: , h2.CM_BILL_CUST_ACCOUNT_ID source_72
72949: , h1.CM_BILL_USES_SITE_USE_ID source_73
72950: FROM xla_events_gt xet
72951: , AR_CM_BILL_SITE_USES_H_V h1
72952: , AR_CM_BILL_TO_CUST_H_V h2
72953: , AR_CREDIT_MEMO_H_V h5
72954: , AR_SYSTEM_PARAM_H_V h8
73010: , l3.CM_LINE_ACCTD_AMT source_71
73011: , l4.CM_TAX_LINE_ID source_74
73012: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_75
73013: , l4.CM_LINE_DIST_AMT source_76
73014: FROM xla_events_gt xet
73015: , AR_CM_LINES_BASE_V l3
73016: , AR_CM_LINES_L_V l4
73017: , AR_DISTRIBUTIONS_L_V l6
73018: , AR_RECEIVABLES_TRX_ACT_S_V l7
74283:
74284: ELSE null
74285: END source_value
74286: , null source_meaning
74287: FROM xla_events_gt xet
74288: , AR_BILL_TO_CUSTOMERS_S_V h1
74289: , AR_BILL_TO_SITE_USES_S_V h2
74290: , AR_TRANSACTIONS_S_V h5
74291: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74430:
74431: ELSE null
74432: END source_value
74433: , null source_meaning
74434: FROM xla_events_gt xet
74435: , AR_CUST_TRX_LINES_BASE_V l3
74436: , AR_CUST_TRX_LINES_L_V l4
74437: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
74438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74652: , h2.BILL_USES_SITE_USE_ID source_50
74653: , h5.XLA_PARTY_TYPE source_51
74654: , h5.TRX_INVOICE_CURRENCY_CODE source_59
74655: , h5.TRX_DOC_SEQUENCE_ID source_120
74656: FROM xla_events_gt xet
74657: , AR_BILL_TO_CUSTOMERS_S_V h1
74658: , AR_BILL_TO_SITE_USES_S_V h2
74659: , AR_TRANSACTIONS_S_V h5
74660: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74706: , l3.TRX_LINE_CUR_CONVERSION_RATE source_61
74707: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
74708: , l3.TRX_LINE_ACCTD_AMT source_63
74709: , l4.TRX_TAX_LINE_ID source_97
74710: FROM xla_events_gt xet
74711: , AR_CUST_TRX_LINES_BASE_V l3
74712: , AR_CUST_TRX_LINES_L_V l4
74713: WHERE xet.event_id between x_first_event_id and x_last_event_id
74714: and xet.event_date between p_pad_start_date and p_pad_end_date
75796:
75797: ELSE null
75798: END source_value
75799: , null source_meaning
75800: FROM xla_events_gt xet
75801: , AR_BILL_TO_CUSTOMERS_S_V h1
75802: , AR_BILL_TO_SITE_USES_S_V h2
75803: , AR_TRANSACTIONS_S_V h5
75804: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75938:
75939: ELSE null
75940: END source_value
75941: , null source_meaning
75942: FROM xla_events_gt xet
75943: , AR_CUST_TRX_LINES_BASE_V l3
75944: , AR_CUST_TRX_LINES_L_V l4
75945: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75946: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76158: , h2.BILL_USES_SITE_USE_ID source_50
76159: , h5.XLA_PARTY_TYPE source_51
76160: , h5.TRX_INVOICE_CURRENCY_CODE source_59
76161: , h5.TRX_DOC_SEQUENCE_ID source_120
76162: FROM xla_events_gt xet
76163: , AR_BILL_TO_CUSTOMERS_S_V h1
76164: , AR_BILL_TO_SITE_USES_S_V h2
76165: , AR_TRANSACTIONS_S_V h5
76166: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76211: , l3.TRX_LINE_CUR_CONVERSION_DATE source_60
76212: , l3.TRX_LINE_CUR_CONVERSION_RATE source_61
76213: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
76214: , l3.TRX_LINE_ACCTD_AMT source_63
76215: FROM xla_events_gt xet
76216: , AR_CUST_TRX_LINES_BASE_V l3
76217: , AR_CUST_TRX_LINES_L_V l4
76218: WHERE xet.event_id between x_first_event_id and x_last_event_id
76219: and xet.event_date between p_pad_start_date and p_pad_end_date
77118: WHEN 17 THEN fvl124.meaning
77119:
77120: ELSE null
77121: END source_meaning
77122: FROM xla_events_gt xet
77123: , AR_BILL_TO_CUSTOMERS_S_V h1
77124: , AR_BILL_TO_SITE_USES_S_V h2
77125: , AR_REMIT_BANK_ACCT_H_V h3
77126: , AR_TRANSACTIONS_S_V h4
77346: WHEN 23 THEN fvl96.meaning
77347:
77348: ELSE null
77349: END source_meaning
77350: FROM xla_events_gt xet
77351: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77352: , fnd_lookup_values fvl13
77353: , fnd_lookup_values fvl77
77354: , fnd_lookup_values fvl78
77641: , h6.JLBR_EXCHG_LOSS_CCID source_122
77642: , h6.JLBR_GL_DATE source_123
77643: , h6.JLBR_TRANSFER_TO_GL_FLAG source_124
77644: , fvl124.meaning source_124_meaning
77645: FROM xla_events_gt xet
77646: , AR_BILL_TO_CUSTOMERS_S_V h1
77647: , AR_BILL_TO_SITE_USES_S_V h2
77648: , AR_REMIT_BANK_ACCT_H_V h3
77649: , AR_TRANSACTIONS_S_V h4
77721: , l5.JLBR_REVERSED_DIST_ID source_94
77722: , l5.JLBR_REVERSED_DIST_LINK_TYPE source_95
77723: , l5.JLBR_BANK_OCC_TYPE source_96
77724: , fvl96.meaning source_96_meaning
77725: FROM xla_events_gt xet
77726: , JL_BR_AR_COLL_DOC_DISTS_L_V l5
77727: , fnd_lookup_values fvl13
77728: , fnd_lookup_values fvl77
77729: , fnd_lookup_values fvl78
78895:
78896: ELSE null
78897: END source_value
78898: , null source_meaning
78899: FROM xla_events_gt xet
78900: , AR_BILL_TO_CUSTOMERS_S_V h1
78901: , AR_BILL_TO_SITE_USES_S_V h2
78902: , AR_TRANSACTIONS_S_V h5
78903: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
79037:
79038: ELSE null
79039: END source_value
79040: , null source_meaning
79041: FROM xla_events_gt xet
79042: , AR_CUST_TRX_LINES_BASE_V l3
79043: , AR_CUST_TRX_LINES_L_V l4
79044: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
79045: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79257: , h2.BILL_USES_SITE_USE_ID source_50
79258: , h5.XLA_PARTY_TYPE source_51
79259: , h5.TRX_INVOICE_CURRENCY_CODE source_59
79260: , h5.TRX_DOC_SEQUENCE_ID source_120
79261: FROM xla_events_gt xet
79262: , AR_BILL_TO_CUSTOMERS_S_V h1
79263: , AR_BILL_TO_SITE_USES_S_V h2
79264: , AR_TRANSACTIONS_S_V h5
79265: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79310: , l3.TRX_LINE_CUR_CONVERSION_DATE source_60
79311: , l3.TRX_LINE_CUR_CONVERSION_RATE source_61
79312: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
79313: , l3.TRX_LINE_ACCTD_AMT source_63
79314: FROM xla_events_gt xet
79315: , AR_CUST_TRX_LINES_BASE_V l3
79316: , AR_CUST_TRX_LINES_L_V l4
79317: WHERE xet.event_id between x_first_event_id and x_last_event_id
79318: and xet.event_date between p_pad_start_date and p_pad_end_date
80173:
80174: ELSE null
80175: END source_value
80176: , null source_meaning
80177: FROM xla_events_gt xet
80178: , AR_BILL_TO_CUSTOMERS_S_V h1
80179: , AR_BILL_TO_SITE_USES_S_V h2
80180: , AR_TRANSACTIONS_S_V h5
80181: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
80325:
80326: ELSE null
80327: END source_value
80328: , null source_meaning
80329: FROM xla_events_gt xet
80330: , AR_CUST_TRX_LINES_BASE_V l3
80331: , AR_CUST_TRX_LINES_L_V l4
80332: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
80333: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80549: , h2.BILL_USES_SITE_USE_ID source_50
80550: , h5.XLA_PARTY_TYPE source_51
80551: , h5.TRX_INVOICE_CURRENCY_CODE source_59
80552: , h5.TRX_DOC_SEQUENCE_ID source_120
80553: FROM xla_events_gt xet
80554: , AR_BILL_TO_CUSTOMERS_S_V h1
80555: , AR_BILL_TO_SITE_USES_S_V h2
80556: , AR_TRANSACTIONS_S_V h5
80557: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
80604: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
80605: , l3.TRX_LINE_ACCTD_AMT source_63
80606: , l4.TRX_TAX_LINE_ID source_97
80607: , l3.ROUNDING_CORRECTION_FLAG source_98
80608: FROM xla_events_gt xet
80609: , AR_CUST_TRX_LINES_BASE_V l3
80610: , AR_CUST_TRX_LINES_L_V l4
80611: WHERE xet.event_id between x_first_event_id and x_last_event_id
80612: and xet.event_date between p_pad_start_date and p_pad_end_date
81797:
81798: ELSE null
81799: END source_value
81800: , null source_meaning
81801: FROM xla_events_gt xet
81802: , AR_CASH_RECEIPTS_H_V h1
81803: , AR_RCT_METHOD_H_V h4
81804: , AR_REMIT_BANK_ACCT_H_V h5
81805: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
81946:
81947: ELSE null
81948: END source_value
81949: , null source_meaning
81950: FROM xla_events_gt xet
81951: , AR_DISTRIBUTIONS_BASE_V l2
81952: , AR_DISTRIBUTIONS_L_V l3
81953: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
81954: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
82170: , h1.RCT_RECEIPT_DATE source_23
82171: , h1.RCT_DOC_SEQUENCE_CATEGORY source_125
82172: , h1.RCT_DOC_SEQUENCE_ID source_126
82173: , h1.RCT_TRX_ACCT_REVERSAL source_127
82174: FROM xla_events_gt xet
82175: , AR_CASH_RECEIPTS_H_V h1
82176: , AR_RCT_METHOD_H_V h4
82177: , AR_REMIT_BANK_ACCT_H_V h5
82178: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
82225: , l2.DIST_CUR_CONVERSION_TYPE source_47
82226: , l2.DIST_TO_ACCTD_AMT source_48
82227: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_99
82228: , l2.DIST_TO_CUR_CONVERSION_DATE source_100
82229: FROM xla_events_gt xet
82230: , AR_DISTRIBUTIONS_BASE_V l2
82231: , AR_DISTRIBUTIONS_L_V l3
82232: WHERE xet.event_id between x_first_event_id and x_last_event_id
82233: and xet.event_date between p_pad_start_date and p_pad_end_date
83314:
83315: ELSE null
83316: END source_value
83317: , null source_meaning
83318: FROM xla_events_gt xet
83319: , AR_CASH_RECEIPTS_H_V h1
83320: , AR_RCT_METHOD_H_V h5
83321: , AR_RCT_SITE_USES_H_V h6
83322: , AR_REMIT_BANK_ACCT_H_V h8
83565:
83566: ELSE null
83567: END source_value
83568: , null source_meaning
83569: FROM xla_events_gt xet
83570: , AR_CUST_TRX_LINES_L_V l2
83571: , AR_DISTRIBUTIONS_BASE_V l3
83572: , AR_DISTRIBUTIONS_L_V l4
83573: , AR_RECEIVABLES_TRX_ACT_S_V l7
83866: , h1.RCT_PREV_CUSTOMER_SITE_USE_ID source_116
83867: , h1.RCT_DOC_SEQUENCE_CATEGORY source_125
83868: , h1.RCT_DOC_SEQUENCE_ID source_126
83869: , h1.RCT_TRX_ACCT_REVERSAL source_127
83870: FROM xla_events_gt xet
83871: , AR_CASH_RECEIPTS_H_V h1
83872: , AR_RCT_METHOD_H_V h5
83873: , AR_RCT_SITE_USES_H_V h6
83874: , AR_REMIT_BANK_ACCT_H_V h8
83944: , l4.DIST_PARTY_TYPE source_108
83945: , l3.DIST_TO_CUR_CONVERSION_TYPE source_109
83946: , l3.DIST_TO_CUR_CONVERSION_RATE source_110
83947: , l4.DIST_SOURCE_TABLE source_111
83948: FROM xla_events_gt xet
83949: , AR_CUST_TRX_LINES_L_V l2
83950: , AR_DISTRIBUTIONS_BASE_V l3
83951: , AR_DISTRIBUTIONS_L_V l4
83952: , AR_RECEIVABLES_TRX_ACT_S_V l7
86239: ,p_level => C_LEVEL_STATEMENT
86240: ,p_module => l_log_module);
86241:
86242: trace
86243: (p_msg => '# of events in xla_events_gt: '
86244: ||xla_context_pkg.get_event_count_context
86245: ,p_level => C_LEVEL_STATEMENT
86246: ,p_module => l_log_module);
86247: