[Home] [Help]
52838:
52839: ELSE null
52840: END source_value
52841: , null source_meaning
52842: FROM xla_events_gt xet
52843: , AR_ADJUSTMENTS_H_V h1
52844: , AR_BILL_TO_CUSTOMERS_S_V h2
52845: , AR_BILL_TO_SITE_USES_S_V h3
52846: , AR_RECEIVABLES_TRX_ACT_S_V h6
52989:
52990: ELSE null
52991: END source_value
52992: , null source_meaning
52993: FROM xla_events_gt xet
52994: , AR_DISTRIBUTIONS_BASE_V l4
52995: , AR_DISTRIBUTIONS_L_V l5
52996: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
52997: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
53208: , h7.XLA_PARTY_TYPE source_25
53209: , h1.ADJ_DOC_SEQUENCE_CATEGORY source_71
53210: , h1.ADJ_DOC_SEQUENCE_ID source_72
53211: , h1.ADJ_DOC_SEQUENCE_VALUE source_73
53212: FROM xla_events_gt xet
53213: , AR_ADJUSTMENTS_H_V h1
53214: , AR_BILL_TO_CUSTOMERS_S_V h2
53215: , AR_BILL_TO_SITE_USES_S_V h3
53216: , AR_RECEIVABLES_TRX_ACT_S_V h6
53266: , l4.DIST_CUR_CONVERSION_DATE source_19
53267: , l4.DIST_CUR_CONVERSION_RATE source_20
53268: , l4.DIST_CUR_CONVERSION_TYPE source_21
53269: , l4.DIST_TO_ACCTD_AMT source_22
53270: FROM xla_events_gt xet
53271: , AR_DISTRIBUTIONS_BASE_V l4
53272: , AR_DISTRIBUTIONS_L_V l5
53273: WHERE xet.event_id between x_first_event_id and x_last_event_id
53274: and xet.event_date between p_pad_start_date and p_pad_end_date
54234:
54235: ELSE null
54236: END source_value
54237: , null source_meaning
54238: FROM xla_events_gt xet
54239: , AR_BILL_TO_CUSTOMERS_S_V h1
54240: , AR_BILL_TO_SITE_USES_S_V h2
54241: , AR_TRANSACTIONS_S_V h5
54242: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
54376:
54377: ELSE null
54378: END source_value
54379: , null source_meaning
54380: FROM xla_events_gt xet
54381: , AR_CUST_TRX_LINES_BASE_V l3
54382: , AR_CUST_TRX_LINES_L_V l4
54383: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
54384: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54590: , h5.TRX_INVOICE_CURRENCY_CODE source_30
54591: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
54592: , h5.TRX_DOC_SEQUENCE_ID source_76
54593: , h5.TRX_DOC_SEQUENCE_VALUE source_77
54594: FROM xla_events_gt xet
54595: , AR_BILL_TO_CUSTOMERS_S_V h1
54596: , AR_BILL_TO_SITE_USES_S_V h2
54597: , AR_TRANSACTIONS_S_V h5
54598: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
54643: , l3.TRX_LINE_CUR_CONVERSION_DATE source_31
54644: , l3.TRX_LINE_CUR_CONVERSION_RATE source_32
54645: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
54646: , l3.TRX_LINE_ACCTD_AMT source_34
54647: FROM xla_events_gt xet
54648: , AR_CUST_TRX_LINES_BASE_V l3
54649: , AR_CUST_TRX_LINES_L_V l4
54650: WHERE xet.event_id between x_first_event_id and x_last_event_id
54651: and xet.event_date between p_pad_start_date and p_pad_end_date
55485:
55486: ELSE null
55487: END source_value
55488: , null source_meaning
55489: FROM xla_events_gt xet
55490: , AR_CM_BILL_SITE_USES_H_V h1
55491: , AR_CM_BILL_TO_CUST_H_V h2
55492: , AR_CREDIT_MEMO_H_V h5
55493: , AR_SYSTEM_PARAM_H_V h8
55659:
55660: ELSE null
55661: END source_value
55662: , null source_meaning
55663: FROM xla_events_gt xet
55664: , AR_CM_LINES_BASE_V l3
55665: , AR_CM_LINES_L_V l4
55666: , AR_DISTRIBUTIONS_L_V l6
55667: , AR_RECEIVABLES_TRX_ACT_S_V l7
55894: , h5.CM_INVOICE_CURRENCY_CODE source_37
55895: , h2.CM_BILL_CUST_ACCOUNT_ID source_43
55896: , h1.CM_BILL_USES_SITE_USE_ID source_44
55897: , h5.CM_INVOICING_RULE_ID source_50
55898: FROM xla_events_gt xet
55899: , AR_CM_BILL_SITE_USES_H_V h1
55900: , AR_CM_BILL_TO_CUST_H_V h2
55901: , AR_CREDIT_MEMO_H_V h5
55902: , AR_SYSTEM_PARAM_H_V h8
55955: , l3.CM_LINE_ACCTD_AMT source_42
55956: , l4.CM_TAX_LINE_ID source_45
55957: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_46
55958: , l4.CM_LINE_DIST_AMT source_47
55959: FROM xla_events_gt xet
55960: , AR_CM_LINES_BASE_V l3
55961: , AR_CM_LINES_L_V l4
55962: , AR_DISTRIBUTIONS_L_V l6
55963: , AR_RECEIVABLES_TRX_ACT_S_V l7
57109:
57110: ELSE null
57111: END source_value
57112: , null source_meaning
57113: FROM xla_events_gt xet
57114: , AR_BILL_TO_CUSTOMERS_S_V h1
57115: , AR_BILL_TO_SITE_USES_S_V h2
57116: , AR_TRANSACTIONS_S_V h5
57117: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
57256:
57257: ELSE null
57258: END source_value
57259: , null source_meaning
57260: FROM xla_events_gt xet
57261: , AR_CUST_TRX_LINES_BASE_V l3
57262: , AR_CUST_TRX_LINES_L_V l4
57263: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
57264: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57478: , h5.TRX_INVOICING_RULE_ID source_51
57479: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
57480: , h5.TRX_DOC_SEQUENCE_ID source_76
57481: , h5.TRX_DOC_SEQUENCE_VALUE source_77
57482: FROM xla_events_gt xet
57483: , AR_BILL_TO_CUSTOMERS_S_V h1
57484: , AR_BILL_TO_SITE_USES_S_V h2
57485: , AR_TRANSACTIONS_S_V h5
57486: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57532: , l3.TRX_LINE_CUR_CONVERSION_RATE source_32
57533: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
57534: , l3.TRX_LINE_ACCTD_AMT source_34
57535: , l4.TRX_TAX_LINE_ID source_48
57536: FROM xla_events_gt xet
57537: , AR_CUST_TRX_LINES_BASE_V l3
57538: , AR_CUST_TRX_LINES_L_V l4
57539: WHERE xet.event_id between x_first_event_id and x_last_event_id
57540: and xet.event_date between p_pad_start_date and p_pad_end_date
58570:
58571: ELSE null
58572: END source_value
58573: , null source_meaning
58574: FROM xla_events_gt xet
58575: , AR_BILL_TO_CUSTOMERS_S_V h1
58576: , AR_BILL_TO_SITE_USES_S_V h2
58577: , AR_TRANSACTIONS_S_V h5
58578: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
58712:
58713: ELSE null
58714: END source_value
58715: , null source_meaning
58716: FROM xla_events_gt xet
58717: , AR_CUST_TRX_LINES_BASE_V l3
58718: , AR_CUST_TRX_LINES_L_V l4
58719: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
58720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58926: , h5.TRX_INVOICE_CURRENCY_CODE source_30
58927: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
58928: , h5.TRX_DOC_SEQUENCE_ID source_76
58929: , h5.TRX_DOC_SEQUENCE_VALUE source_77
58930: FROM xla_events_gt xet
58931: , AR_BILL_TO_CUSTOMERS_S_V h1
58932: , AR_BILL_TO_SITE_USES_S_V h2
58933: , AR_TRANSACTIONS_S_V h5
58934: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
58979: , l3.TRX_LINE_CUR_CONVERSION_DATE source_31
58980: , l3.TRX_LINE_CUR_CONVERSION_RATE source_32
58981: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
58982: , l3.TRX_LINE_ACCTD_AMT source_34
58983: FROM xla_events_gt xet
58984: , AR_CUST_TRX_LINES_BASE_V l3
58985: , AR_CUST_TRX_LINES_L_V l4
58986: WHERE xet.event_id between x_first_event_id and x_last_event_id
58987: and xet.event_date between p_pad_start_date and p_pad_end_date
59816:
59817: ELSE null
59818: END source_value
59819: , null source_meaning
59820: FROM xla_events_gt xet
59821: , AR_BILL_TO_CUSTOMERS_S_V h1
59822: , AR_BILL_TO_SITE_USES_S_V h2
59823: , AR_TRANSACTIONS_S_V h5
59824: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
59958:
59959: ELSE null
59960: END source_value
59961: , null source_meaning
59962: FROM xla_events_gt xet
59963: , AR_CUST_TRX_LINES_BASE_V l3
59964: , AR_CUST_TRX_LINES_L_V l4
59965: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
59966: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60172: , h5.TRX_INVOICE_CURRENCY_CODE source_30
60173: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
60174: , h5.TRX_DOC_SEQUENCE_ID source_76
60175: , h5.TRX_DOC_SEQUENCE_VALUE source_77
60176: FROM xla_events_gt xet
60177: , AR_BILL_TO_CUSTOMERS_S_V h1
60178: , AR_BILL_TO_SITE_USES_S_V h2
60179: , AR_TRANSACTIONS_S_V h5
60180: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
60225: , l3.TRX_LINE_CUR_CONVERSION_DATE source_31
60226: , l3.TRX_LINE_CUR_CONVERSION_RATE source_32
60227: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
60228: , l3.TRX_LINE_ACCTD_AMT source_34
60229: FROM xla_events_gt xet
60230: , AR_CUST_TRX_LINES_BASE_V l3
60231: , AR_CUST_TRX_LINES_L_V l4
60232: WHERE xet.event_id between x_first_event_id and x_last_event_id
60233: and xet.event_date between p_pad_start_date and p_pad_end_date
61072:
61073: ELSE null
61074: END source_value
61075: , null source_meaning
61076: FROM xla_events_gt xet
61077: , AR_BILL_TO_CUSTOMERS_S_V h1
61078: , AR_BILL_TO_SITE_USES_S_V h2
61079: , AR_TRANSACTIONS_S_V h5
61080: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
61224:
61225: ELSE null
61226: END source_value
61227: , null source_meaning
61228: FROM xla_events_gt xet
61229: , AR_CUST_TRX_LINES_BASE_V l3
61230: , AR_CUST_TRX_LINES_L_V l4
61231: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
61232: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61448: , h5.TRX_INVOICING_RULE_ID source_51
61449: , h5.TRX_DOC_SEQUENCE_CATEGORY source_75
61450: , h5.TRX_DOC_SEQUENCE_ID source_76
61451: , h5.TRX_DOC_SEQUENCE_VALUE source_77
61452: FROM xla_events_gt xet
61453: , AR_BILL_TO_CUSTOMERS_S_V h1
61454: , AR_BILL_TO_SITE_USES_S_V h2
61455: , AR_TRANSACTIONS_S_V h5
61456: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61503: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
61504: , l3.TRX_LINE_ACCTD_AMT source_34
61505: , l4.TRX_TAX_LINE_ID source_48
61506: , l3.ROUNDING_CORRECTION_FLAG source_49
61507: FROM xla_events_gt xet
61508: , AR_CUST_TRX_LINES_BASE_V l3
61509: , AR_CUST_TRX_LINES_L_V l4
61510: WHERE xet.event_id between x_first_event_id and x_last_event_id
61511: and xet.event_date between p_pad_start_date and p_pad_end_date
62560:
62561: ELSE null
62562: END source_value
62563: , null source_meaning
62564: FROM xla_events_gt xet
62565: , AR_CASH_RECEIPTS_H_V h1
62566: , AR_RCT_METHOD_H_V h4
62567: , AR_REMIT_BANK_ACCT_H_V h5
62568: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
62709:
62710: ELSE null
62711: END source_value
62712: , null source_meaning
62713: FROM xla_events_gt xet
62714: , AR_DISTRIBUTIONS_BASE_V l2
62715: , AR_DISTRIBUTIONS_L_V l3
62716: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
62717: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
62936: , h1.RCT_DOC_SEQUENCE_CATEGORY source_78
62937: , h1.RCT_DOC_SEQUENCE_ID source_79
62938: , h1.RCT_DOC_SEQUENCE_VALUE source_80
62939: , h1.RCT_TRX_ACCT_REVERSAL source_81
62940: FROM xla_events_gt xet
62941: , AR_CASH_RECEIPTS_H_V h1
62942: , AR_RCT_METHOD_H_V h4
62943: , AR_REMIT_BANK_ACCT_H_V h5
62944: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
62991: , l2.DIST_CUR_CONVERSION_TYPE source_21
62992: , l2.DIST_TO_ACCTD_AMT source_22
62993: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_52
62994: , l2.DIST_TO_CUR_CONVERSION_DATE source_53
62995: FROM xla_events_gt xet
62996: , AR_DISTRIBUTIONS_BASE_V l2
62997: , AR_DISTRIBUTIONS_L_V l3
62998: WHERE xet.event_id between x_first_event_id and x_last_event_id
62999: and xet.event_date between p_pad_start_date and p_pad_end_date
64124:
64125: ELSE null
64126: END source_value
64127: , null source_meaning
64128: FROM xla_events_gt xet
64129: , AR_CASH_RECEIPTS_H_V h1
64130: , AR_RCT_METHOD_H_V h5
64131: , AR_RCT_SITE_USES_H_V h6
64132: , AR_REMIT_BANK_ACCT_H_V h8
64365:
64366: ELSE null
64367: END source_value
64368: , null source_meaning
64369: FROM xla_events_gt xet
64370: , AR_CUST_TRX_LINES_L_V l2
64371: , AR_DISTRIBUTIONS_BASE_V l3
64372: , AR_DISTRIBUTIONS_L_V l4
64373: , AR_RECEIVABLES_TRX_ACT_S_V l7
64656: , h1.RCT_DOC_SEQUENCE_CATEGORY source_78
64657: , h1.RCT_DOC_SEQUENCE_ID source_79
64658: , h1.RCT_DOC_SEQUENCE_VALUE source_80
64659: , h1.RCT_TRX_ACCT_REVERSAL source_81
64660: FROM xla_events_gt xet
64661: , AR_CASH_RECEIPTS_H_V h1
64662: , AR_RCT_METHOD_H_V h5
64663: , AR_RCT_SITE_USES_H_V h6
64664: , AR_REMIT_BANK_ACCT_H_V h8
64732: , l4.DIST_PARTY_TYPE source_64
64733: , l3.DIST_TO_CUR_CONVERSION_TYPE source_65
64734: , l3.DIST_TO_CUR_CONVERSION_RATE source_66
64735: , l4.DIST_SOURCE_TABLE source_67
64736: FROM xla_events_gt xet
64737: , AR_CUST_TRX_LINES_L_V l2
64738: , AR_DISTRIBUTIONS_BASE_V l3
64739: , AR_DISTRIBUTIONS_L_V l4
64740: , AR_RECEIVABLES_TRX_ACT_S_V l7
67122: ,p_level => C_LEVEL_STATEMENT
67123: ,p_module => l_log_module);
67124:
67125: trace
67126: (p_msg => '# of events in xla_events_gt: '
67127: ||xla_context_pkg.get_event_count_context
67128: ,p_level => C_LEVEL_STATEMENT
67129: ,p_module => l_log_module);
67130: