[Home] [Help]
53140:
53141: ELSE null
53142: END source_value
53143: , null source_meaning
53144: FROM xla_events_gt xet
53145: , AR_ADJUSTMENTS_H_V h1
53146: , AR_BILL_TO_CUSTOMERS_S_V h2
53147: , AR_BILL_TO_SITE_USES_S_V h3
53148: , AR_RECEIVABLES_TRX_ACT_S_V h6
53291:
53292: ELSE null
53293: END source_value
53294: , null source_meaning
53295: FROM xla_events_gt xet
53296: , AR_DISTRIBUTIONS_BASE_V l4
53297: , AR_DISTRIBUTIONS_L_V l5
53298: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
53299: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
53510: , h7.XLA_PARTY_TYPE source_27
53511: , h1.ADJ_DOC_SEQUENCE_CATEGORY source_73
53512: , h1.ADJ_DOC_SEQUENCE_ID source_74
53513: , h1.ADJ_DOC_SEQUENCE_VALUE source_75
53514: FROM xla_events_gt xet
53515: , AR_ADJUSTMENTS_H_V h1
53516: , AR_BILL_TO_CUSTOMERS_S_V h2
53517: , AR_BILL_TO_SITE_USES_S_V h3
53518: , AR_RECEIVABLES_TRX_ACT_S_V h6
53568: , l4.DIST_CUR_CONVERSION_DATE source_21
53569: , l4.DIST_CUR_CONVERSION_RATE source_22
53570: , l4.DIST_CUR_CONVERSION_TYPE source_23
53571: , l4.DIST_TO_ACCTD_AMT source_24
53572: FROM xla_events_gt xet
53573: , AR_DISTRIBUTIONS_BASE_V l4
53574: , AR_DISTRIBUTIONS_L_V l5
53575: WHERE xet.event_id between x_first_event_id and x_last_event_id
53576: and xet.event_date between p_pad_start_date and p_pad_end_date
54505:
54506: ELSE null
54507: END source_value
54508: , null source_meaning
54509: FROM xla_events_gt xet
54510: , AR_BILL_TO_CUSTOMERS_S_V h1
54511: , AR_BILL_TO_SITE_USES_S_V h2
54512: , AR_TRANSACTIONS_S_V h5
54513: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
54647:
54648: ELSE null
54649: END source_value
54650: , null source_meaning
54651: FROM xla_events_gt xet
54652: , AR_CUST_TRX_LINES_BASE_V l3
54653: , AR_CUST_TRX_LINES_L_V l4
54654: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
54655: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54861: , h5.TRX_INVOICE_CURRENCY_CODE source_32
54862: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
54863: , h5.TRX_DOC_SEQUENCE_ID source_78
54864: , h5.TRX_DOC_SEQUENCE_VALUE source_79
54865: FROM xla_events_gt xet
54866: , AR_BILL_TO_CUSTOMERS_S_V h1
54867: , AR_BILL_TO_SITE_USES_S_V h2
54868: , AR_TRANSACTIONS_S_V h5
54869: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
54914: , l3.TRX_LINE_CUR_CONVERSION_DATE source_33
54915: , l3.TRX_LINE_CUR_CONVERSION_RATE source_34
54916: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
54917: , l3.TRX_LINE_ACCTD_AMT source_36
54918: FROM xla_events_gt xet
54919: , AR_CUST_TRX_LINES_BASE_V l3
54920: , AR_CUST_TRX_LINES_L_V l4
54921: WHERE xet.event_id between x_first_event_id and x_last_event_id
54922: and xet.event_date between p_pad_start_date and p_pad_end_date
55756:
55757: ELSE null
55758: END source_value
55759: , null source_meaning
55760: FROM xla_events_gt xet
55761: , AR_CM_BILL_SITE_USES_H_V h1
55762: , AR_CM_BILL_TO_CUST_H_V h2
55763: , AR_CREDIT_MEMO_H_V h5
55764: , AR_SYSTEM_PARAM_H_V h8
55930:
55931: ELSE null
55932: END source_value
55933: , null source_meaning
55934: FROM xla_events_gt xet
55935: , AR_CM_LINES_BASE_V l3
55936: , AR_CM_LINES_L_V l4
55937: , AR_DISTRIBUTIONS_L_V l6
55938: , AR_RECEIVABLES_TRX_ACT_S_V l7
56165: , h5.CM_INVOICE_CURRENCY_CODE source_39
56166: , h2.CM_BILL_CUST_ACCOUNT_ID source_45
56167: , h1.CM_BILL_USES_SITE_USE_ID source_46
56168: , h5.CM_INVOICING_RULE_ID source_52
56169: FROM xla_events_gt xet
56170: , AR_CM_BILL_SITE_USES_H_V h1
56171: , AR_CM_BILL_TO_CUST_H_V h2
56172: , AR_CREDIT_MEMO_H_V h5
56173: , AR_SYSTEM_PARAM_H_V h8
56226: , l3.CM_LINE_ACCTD_AMT source_44
56227: , l4.CM_TAX_LINE_ID source_47
56228: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_48
56229: , l4.CM_LINE_DIST_AMT source_49
56230: FROM xla_events_gt xet
56231: , AR_CM_LINES_BASE_V l3
56232: , AR_CM_LINES_L_V l4
56233: , AR_DISTRIBUTIONS_L_V l6
56234: , AR_RECEIVABLES_TRX_ACT_S_V l7
57380:
57381: ELSE null
57382: END source_value
57383: , null source_meaning
57384: FROM xla_events_gt xet
57385: , AR_BILL_TO_CUSTOMERS_S_V h1
57386: , AR_BILL_TO_SITE_USES_S_V h2
57387: , AR_TRANSACTIONS_S_V h5
57388: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
57527:
57528: ELSE null
57529: END source_value
57530: , null source_meaning
57531: FROM xla_events_gt xet
57532: , AR_CUST_TRX_LINES_BASE_V l3
57533: , AR_CUST_TRX_LINES_L_V l4
57534: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
57535: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57749: , h5.TRX_INVOICING_RULE_ID source_53
57750: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
57751: , h5.TRX_DOC_SEQUENCE_ID source_78
57752: , h5.TRX_DOC_SEQUENCE_VALUE source_79
57753: FROM xla_events_gt xet
57754: , AR_BILL_TO_CUSTOMERS_S_V h1
57755: , AR_BILL_TO_SITE_USES_S_V h2
57756: , AR_TRANSACTIONS_S_V h5
57757: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
57803: , l3.TRX_LINE_CUR_CONVERSION_RATE source_34
57804: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
57805: , l3.TRX_LINE_ACCTD_AMT source_36
57806: , l4.TRX_TAX_LINE_ID source_50
57807: FROM xla_events_gt xet
57808: , AR_CUST_TRX_LINES_BASE_V l3
57809: , AR_CUST_TRX_LINES_L_V l4
57810: WHERE xet.event_id between x_first_event_id and x_last_event_id
57811: and xet.event_date between p_pad_start_date and p_pad_end_date
58841:
58842: ELSE null
58843: END source_value
58844: , null source_meaning
58845: FROM xla_events_gt xet
58846: , AR_BILL_TO_CUSTOMERS_S_V h1
58847: , AR_BILL_TO_SITE_USES_S_V h2
58848: , AR_TRANSACTIONS_S_V h5
58849: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
58983:
58984: ELSE null
58985: END source_value
58986: , null source_meaning
58987: FROM xla_events_gt xet
58988: , AR_CUST_TRX_LINES_BASE_V l3
58989: , AR_CUST_TRX_LINES_L_V l4
58990: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
58991: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59197: , h5.TRX_INVOICE_CURRENCY_CODE source_32
59198: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
59199: , h5.TRX_DOC_SEQUENCE_ID source_78
59200: , h5.TRX_DOC_SEQUENCE_VALUE source_79
59201: FROM xla_events_gt xet
59202: , AR_BILL_TO_CUSTOMERS_S_V h1
59203: , AR_BILL_TO_SITE_USES_S_V h2
59204: , AR_TRANSACTIONS_S_V h5
59205: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
59250: , l3.TRX_LINE_CUR_CONVERSION_DATE source_33
59251: , l3.TRX_LINE_CUR_CONVERSION_RATE source_34
59252: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
59253: , l3.TRX_LINE_ACCTD_AMT source_36
59254: FROM xla_events_gt xet
59255: , AR_CUST_TRX_LINES_BASE_V l3
59256: , AR_CUST_TRX_LINES_L_V l4
59257: WHERE xet.event_id between x_first_event_id and x_last_event_id
59258: and xet.event_date between p_pad_start_date and p_pad_end_date
60087:
60088: ELSE null
60089: END source_value
60090: , null source_meaning
60091: FROM xla_events_gt xet
60092: , AR_BILL_TO_CUSTOMERS_S_V h1
60093: , AR_BILL_TO_SITE_USES_S_V h2
60094: , AR_TRANSACTIONS_S_V h5
60095: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
60229:
60230: ELSE null
60231: END source_value
60232: , null source_meaning
60233: FROM xla_events_gt xet
60234: , AR_CUST_TRX_LINES_BASE_V l3
60235: , AR_CUST_TRX_LINES_L_V l4
60236: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
60237: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60443: , h5.TRX_INVOICE_CURRENCY_CODE source_32
60444: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
60445: , h5.TRX_DOC_SEQUENCE_ID source_78
60446: , h5.TRX_DOC_SEQUENCE_VALUE source_79
60447: FROM xla_events_gt xet
60448: , AR_BILL_TO_CUSTOMERS_S_V h1
60449: , AR_BILL_TO_SITE_USES_S_V h2
60450: , AR_TRANSACTIONS_S_V h5
60451: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
60496: , l3.TRX_LINE_CUR_CONVERSION_DATE source_33
60497: , l3.TRX_LINE_CUR_CONVERSION_RATE source_34
60498: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
60499: , l3.TRX_LINE_ACCTD_AMT source_36
60500: FROM xla_events_gt xet
60501: , AR_CUST_TRX_LINES_BASE_V l3
60502: , AR_CUST_TRX_LINES_L_V l4
60503: WHERE xet.event_id between x_first_event_id and x_last_event_id
60504: and xet.event_date between p_pad_start_date and p_pad_end_date
61343:
61344: ELSE null
61345: END source_value
61346: , null source_meaning
61347: FROM xla_events_gt xet
61348: , AR_BILL_TO_CUSTOMERS_S_V h1
61349: , AR_BILL_TO_SITE_USES_S_V h2
61350: , AR_TRANSACTIONS_S_V h5
61351: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
61495:
61496: ELSE null
61497: END source_value
61498: , null source_meaning
61499: FROM xla_events_gt xet
61500: , AR_CUST_TRX_LINES_BASE_V l3
61501: , AR_CUST_TRX_LINES_L_V l4
61502: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
61503: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61719: , h5.TRX_INVOICING_RULE_ID source_53
61720: , h5.TRX_DOC_SEQUENCE_CATEGORY source_77
61721: , h5.TRX_DOC_SEQUENCE_ID source_78
61722: , h5.TRX_DOC_SEQUENCE_VALUE source_79
61723: FROM xla_events_gt xet
61724: , AR_BILL_TO_CUSTOMERS_S_V h1
61725: , AR_BILL_TO_SITE_USES_S_V h2
61726: , AR_TRANSACTIONS_S_V h5
61727: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
61774: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
61775: , l3.TRX_LINE_ACCTD_AMT source_36
61776: , l4.TRX_TAX_LINE_ID source_50
61777: , l3.ROUNDING_CORRECTION_FLAG source_51
61778: FROM xla_events_gt xet
61779: , AR_CUST_TRX_LINES_BASE_V l3
61780: , AR_CUST_TRX_LINES_L_V l4
61781: WHERE xet.event_id between x_first_event_id and x_last_event_id
61782: and xet.event_date between p_pad_start_date and p_pad_end_date
62831:
62832: ELSE null
62833: END source_value
62834: , null source_meaning
62835: FROM xla_events_gt xet
62836: , AR_CASH_RECEIPTS_H_V h1
62837: , AR_RCT_METHOD_H_V h4
62838: , AR_REMIT_BANK_ACCT_H_V h5
62839: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
62980:
62981: ELSE null
62982: END source_value
62983: , null source_meaning
62984: FROM xla_events_gt xet
62985: , AR_DISTRIBUTIONS_BASE_V l2
62986: , AR_DISTRIBUTIONS_L_V l3
62987: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
62988: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
63207: , h1.RCT_DOC_SEQUENCE_CATEGORY source_80
63208: , h1.RCT_DOC_SEQUENCE_ID source_81
63209: , h1.RCT_DOC_SEQUENCE_VALUE source_82
63210: , h1.RCT_TRX_ACCT_REVERSAL source_83
63211: FROM xla_events_gt xet
63212: , AR_CASH_RECEIPTS_H_V h1
63213: , AR_RCT_METHOD_H_V h4
63214: , AR_REMIT_BANK_ACCT_H_V h5
63215: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
63262: , l2.DIST_CUR_CONVERSION_TYPE source_23
63263: , l2.DIST_TO_ACCTD_AMT source_24
63264: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_54
63265: , l2.DIST_TO_CUR_CONVERSION_DATE source_55
63266: FROM xla_events_gt xet
63267: , AR_DISTRIBUTIONS_BASE_V l2
63268: , AR_DISTRIBUTIONS_L_V l3
63269: WHERE xet.event_id between x_first_event_id and x_last_event_id
63270: and xet.event_date between p_pad_start_date and p_pad_end_date
64405:
64406: ELSE null
64407: END source_value
64408: , null source_meaning
64409: FROM xla_events_gt xet
64410: , AR_CASH_RECEIPTS_H_V h1
64411: , AR_RCT_METHOD_H_V h5
64412: , AR_RCT_SITE_USES_H_V h6
64413: , AR_REMIT_BANK_ACCT_H_V h8
64646:
64647: ELSE null
64648: END source_value
64649: , null source_meaning
64650: FROM xla_events_gt xet
64651: , AR_CUST_TRX_LINES_L_V l2
64652: , AR_DISTRIBUTIONS_BASE_V l3
64653: , AR_DISTRIBUTIONS_L_V l4
64654: , AR_RECEIVABLES_TRX_ACT_S_V l7
64943: , h1.RCT_DOC_SEQUENCE_CATEGORY source_80
64944: , h1.RCT_DOC_SEQUENCE_ID source_81
64945: , h1.RCT_DOC_SEQUENCE_VALUE source_82
64946: , h1.RCT_TRX_ACCT_REVERSAL source_83
64947: FROM xla_events_gt xet
64948: , AR_CASH_RECEIPTS_H_V h1
64949: , AR_RCT_METHOD_H_V h5
64950: , AR_RCT_SITE_USES_H_V h6
64951: , AR_REMIT_BANK_ACCT_H_V h8
65019: , l4.DIST_PARTY_TYPE source_66
65020: , l3.DIST_TO_CUR_CONVERSION_TYPE source_67
65021: , l3.DIST_TO_CUR_CONVERSION_RATE source_68
65022: , l4.DIST_SOURCE_TABLE source_69
65023: FROM xla_events_gt xet
65024: , AR_CUST_TRX_LINES_L_V l2
65025: , AR_DISTRIBUTIONS_BASE_V l3
65026: , AR_DISTRIBUTIONS_L_V l4
65027: , AR_RECEIVABLES_TRX_ACT_S_V l7
67449: ,p_level => C_LEVEL_STATEMENT
67450: ,p_module => l_log_module);
67451:
67452: trace
67453: (p_msg => '# of events in xla_events_gt: '
67454: ||xla_context_pkg.get_event_count_context
67455: ,p_level => C_LEVEL_STATEMENT
67456: ,p_module => l_log_module);
67457: