[Home] [Help]
68966:
68967: ELSE null
68968: END source_value
68969: , null source_meaning
68970: FROM xla_events_gt xet
68971: , AR_ADJUSTMENTS_H_V h1
68972: , AR_BILL_TO_CUSTOMERS_S_V h2
68973: , AR_BILL_TO_SITE_USES_S_V h3
68974: , AR_RECEIVABLES_TRX_ACT_S_V h6
69117:
69118: ELSE null
69119: END source_value
69120: , null source_meaning
69121: FROM xla_events_gt xet
69122: , AR_DISTRIBUTIONS_BASE_V l4
69123: , AR_DISTRIBUTIONS_L_V l5
69124: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
69125: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69336: , h7.XLA_PARTY_TYPE source_32
69337: , h1.ADJ_DOC_SEQUENCE_CATEGORY source_79
69338: , h1.ADJ_DOC_SEQUENCE_ID source_80
69339: , h1.ADJ_DOC_SEQUENCE_VALUE source_81
69340: FROM xla_events_gt xet
69341: , AR_ADJUSTMENTS_H_V h1
69342: , AR_BILL_TO_CUSTOMERS_S_V h2
69343: , AR_BILL_TO_SITE_USES_S_V h3
69344: , AR_RECEIVABLES_TRX_ACT_S_V h6
69394: , l4.DIST_CUR_CONVERSION_DATE source_26
69395: , l4.DIST_CUR_CONVERSION_RATE source_27
69396: , l4.DIST_CUR_CONVERSION_TYPE source_28
69397: , l4.DIST_TO_ACCTD_AMT source_29
69398: FROM xla_events_gt xet
69399: , AR_DISTRIBUTIONS_BASE_V l4
69400: , AR_DISTRIBUTIONS_L_V l5
69401: WHERE xet.event_id between x_first_event_id and x_last_event_id
69402: and xet.event_date between p_pad_start_date and p_pad_end_date
70362:
70363: ELSE null
70364: END source_value
70365: , null source_meaning
70366: FROM xla_events_gt xet
70367: , AR_BILL_TO_CUSTOMERS_S_V h1
70368: , AR_BILL_TO_SITE_USES_S_V h2
70369: , AR_TRANSACTIONS_S_V h5
70370: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
70504:
70505: ELSE null
70506: END source_value
70507: , null source_meaning
70508: FROM xla_events_gt xet
70509: , AR_CUST_TRX_LINES_BASE_V l3
70510: , AR_CUST_TRX_LINES_L_V l4
70511: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
70512: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70718: , h5.TRX_INVOICE_CURRENCY_CODE source_37
70719: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
70720: , h5.TRX_DOC_SEQUENCE_ID source_84
70721: , h5.TRX_DOC_SEQUENCE_VALUE source_85
70722: FROM xla_events_gt xet
70723: , AR_BILL_TO_CUSTOMERS_S_V h1
70724: , AR_BILL_TO_SITE_USES_S_V h2
70725: , AR_TRANSACTIONS_S_V h5
70726: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
70771: , l3.TRX_LINE_CUR_CONVERSION_DATE source_38
70772: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
70773: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
70774: , l3.TRX_LINE_ACCTD_AMT source_41
70775: FROM xla_events_gt xet
70776: , AR_CUST_TRX_LINES_BASE_V l3
70777: , AR_CUST_TRX_LINES_L_V l4
70778: WHERE xet.event_id between x_first_event_id and x_last_event_id
70779: and xet.event_date between p_pad_start_date and p_pad_end_date
71613:
71614: ELSE null
71615: END source_value
71616: , null source_meaning
71617: FROM xla_events_gt xet
71618: , AR_CM_BILL_SITE_USES_H_V h1
71619: , AR_CM_BILL_TO_CUST_H_V h2
71620: , AR_CREDIT_MEMO_H_V h5
71621: , AR_SYSTEM_PARAM_H_V h8
71787:
71788: ELSE null
71789: END source_value
71790: , null source_meaning
71791: FROM xla_events_gt xet
71792: , AR_CM_LINES_BASE_V l3
71793: , AR_CM_LINES_L_V l4
71794: , AR_DISTRIBUTIONS_L_V l6
71795: , AR_RECEIVABLES_TRX_ACT_S_V l7
72022: , h5.CM_INVOICE_CURRENCY_CODE source_44
72023: , h2.CM_BILL_CUST_ACCOUNT_ID source_50
72024: , h1.CM_BILL_USES_SITE_USE_ID source_51
72025: , h5.CM_INVOICING_RULE_ID source_67
72026: FROM xla_events_gt xet
72027: , AR_CM_BILL_SITE_USES_H_V h1
72028: , AR_CM_BILL_TO_CUST_H_V h2
72029: , AR_CREDIT_MEMO_H_V h5
72030: , AR_SYSTEM_PARAM_H_V h8
72083: , l3.CM_LINE_ACCTD_AMT source_49
72084: , l4.CM_TAX_LINE_ID source_52
72085: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_53
72086: , l4.CM_LINE_DIST_AMT source_54
72087: FROM xla_events_gt xet
72088: , AR_CM_LINES_BASE_V l3
72089: , AR_CM_LINES_L_V l4
72090: , AR_DISTRIBUTIONS_L_V l6
72091: , AR_RECEIVABLES_TRX_ACT_S_V l7
73237:
73238: ELSE null
73239: END source_value
73240: , null source_meaning
73241: FROM xla_events_gt xet
73242: , AR_BILL_TO_CUSTOMERS_S_V h1
73243: , AR_BILL_TO_SITE_USES_S_V h2
73244: , AR_TRANSACTIONS_S_V h5
73245: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
73384:
73385: ELSE null
73386: END source_value
73387: , null source_meaning
73388: FROM xla_events_gt xet
73389: , AR_CUST_TRX_LINES_BASE_V l3
73390: , AR_CUST_TRX_LINES_L_V l4
73391: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
73392: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73606: , h5.TRX_INVOICING_RULE_ID source_68
73607: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
73608: , h5.TRX_DOC_SEQUENCE_ID source_84
73609: , h5.TRX_DOC_SEQUENCE_VALUE source_85
73610: FROM xla_events_gt xet
73611: , AR_BILL_TO_CUSTOMERS_S_V h1
73612: , AR_BILL_TO_SITE_USES_S_V h2
73613: , AR_TRANSACTIONS_S_V h5
73614: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73660: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
73661: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
73662: , l3.TRX_LINE_ACCTD_AMT source_41
73663: , l4.TRX_TAX_LINE_ID source_55
73664: FROM xla_events_gt xet
73665: , AR_CUST_TRX_LINES_BASE_V l3
73666: , AR_CUST_TRX_LINES_L_V l4
73667: WHERE xet.event_id between x_first_event_id and x_last_event_id
73668: and xet.event_date between p_pad_start_date and p_pad_end_date
74698:
74699: ELSE null
74700: END source_value
74701: , null source_meaning
74702: FROM xla_events_gt xet
74703: , AR_BILL_TO_CUSTOMERS_S_V h1
74704: , AR_BILL_TO_SITE_USES_S_V h2
74705: , AR_TRANSACTIONS_S_V h5
74706: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
74840:
74841: ELSE null
74842: END source_value
74843: , null source_meaning
74844: FROM xla_events_gt xet
74845: , AR_CUST_TRX_LINES_BASE_V l3
74846: , AR_CUST_TRX_LINES_L_V l4
74847: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75054: , h5.TRX_INVOICE_CURRENCY_CODE source_37
75055: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
75056: , h5.TRX_DOC_SEQUENCE_ID source_84
75057: , h5.TRX_DOC_SEQUENCE_VALUE source_85
75058: FROM xla_events_gt xet
75059: , AR_BILL_TO_CUSTOMERS_S_V h1
75060: , AR_BILL_TO_SITE_USES_S_V h2
75061: , AR_TRANSACTIONS_S_V h5
75062: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75107: , l3.TRX_LINE_CUR_CONVERSION_DATE source_38
75108: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
75109: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
75110: , l3.TRX_LINE_ACCTD_AMT source_41
75111: FROM xla_events_gt xet
75112: , AR_CUST_TRX_LINES_BASE_V l3
75113: , AR_CUST_TRX_LINES_L_V l4
75114: WHERE xet.event_id between x_first_event_id and x_last_event_id
75115: and xet.event_date between p_pad_start_date and p_pad_end_date
75944:
75945: ELSE null
75946: END source_value
75947: , null source_meaning
75948: FROM xla_events_gt xet
75949: , AR_BILL_TO_CUSTOMERS_S_V h1
75950: , AR_BILL_TO_SITE_USES_S_V h2
75951: , AR_TRANSACTIONS_S_V h5
75952: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
76086:
76087: ELSE null
76088: END source_value
76089: , null source_meaning
76090: FROM xla_events_gt xet
76091: , AR_CUST_TRX_LINES_BASE_V l3
76092: , AR_CUST_TRX_LINES_L_V l4
76093: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
76094: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76300: , h5.TRX_INVOICE_CURRENCY_CODE source_37
76301: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
76302: , h5.TRX_DOC_SEQUENCE_ID source_84
76303: , h5.TRX_DOC_SEQUENCE_VALUE source_85
76304: FROM xla_events_gt xet
76305: , AR_BILL_TO_CUSTOMERS_S_V h1
76306: , AR_BILL_TO_SITE_USES_S_V h2
76307: , AR_TRANSACTIONS_S_V h5
76308: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76353: , l3.TRX_LINE_CUR_CONVERSION_DATE source_38
76354: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
76355: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
76356: , l3.TRX_LINE_ACCTD_AMT source_41
76357: FROM xla_events_gt xet
76358: , AR_CUST_TRX_LINES_BASE_V l3
76359: , AR_CUST_TRX_LINES_L_V l4
76360: WHERE xet.event_id between x_first_event_id and x_last_event_id
76361: and xet.event_date between p_pad_start_date and p_pad_end_date
77205:
77206: ELSE null
77207: END source_value
77208: , null source_meaning
77209: FROM xla_events_gt xet
77210: , AR_BILL_TO_CUSTOMERS_S_V h1
77211: , AR_BILL_TO_SITE_USES_S_V h2
77212: , AR_TRANSACTIONS_S_V h5
77213: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
77367:
77368: ELSE null
77369: END source_value
77370: , null source_meaning
77371: FROM xla_events_gt xet
77372: , AR_CUST_TRX_LINES_BASE_V l3
77373: , AR_CUST_TRX_LINES_L_V l4
77374: , FV_XLA_AR_REF_V l6
77375: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
77599: , h5.TRX_INVOICING_RULE_ID source_68
77600: , h5.TRX_DOC_SEQUENCE_CATEGORY source_83
77601: , h5.TRX_DOC_SEQUENCE_ID source_84
77602: , h5.TRX_DOC_SEQUENCE_VALUE source_85
77603: FROM xla_events_gt xet
77604: , AR_BILL_TO_CUSTOMERS_S_V h1
77605: , AR_BILL_TO_SITE_USES_S_V h2
77606: , AR_TRANSACTIONS_S_V h5
77607: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77656: , l3.TRX_LINE_ACCTD_AMT source_41
77657: , l4.TRX_TAX_LINE_ID source_55
77658: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_56
77659: , l3.ROUNDING_CORRECTION_FLAG source_66
77660: FROM xla_events_gt xet
77661: , AR_CUST_TRX_LINES_BASE_V l3
77662: , AR_CUST_TRX_LINES_L_V l4
77663: , FV_XLA_AR_REF_V l6
77664: WHERE xet.event_id between x_first_event_id and x_last_event_id
78790:
78791: ELSE null
78792: END source_value
78793: , null source_meaning
78794: FROM xla_events_gt xet
78795: , AR_CASH_RECEIPTS_H_V h1
78796: , AR_RCT_METHOD_H_V h4
78797: , AR_REMIT_BANK_ACCT_H_V h5
78798: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
78969:
78970: ELSE null
78971: END source_value
78972: , null source_meaning
78973: FROM xla_events_gt xet
78974: , AR_DISTRIBUTIONS_BASE_V l2
78975: , AR_DISTRIBUTIONS_L_V l3
78976: , FV_XLA_AR_REF_V l6
78977: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
79209: , h1.RCT_DOC_SEQUENCE_CATEGORY source_86
79210: , h1.RCT_DOC_SEQUENCE_ID source_87
79211: , h1.RCT_DOC_SEQUENCE_VALUE source_88
79212: , h1.RCT_TRX_ACCT_REVERSAL source_89
79213: FROM xla_events_gt xet
79214: , AR_CASH_RECEIPTS_H_V h1
79215: , AR_RCT_METHOD_H_V h4
79216: , AR_REMIT_BANK_ACCT_H_V h5
79217: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
79270: , l2.DIST_TO_ACCTD_AMT source_29
79271: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_56
79272: , l2.DIST_TO_CUR_CONVERSION_DATE source_57
79273: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_69
79274: FROM xla_events_gt xet
79275: , AR_DISTRIBUTIONS_BASE_V l2
79276: , AR_DISTRIBUTIONS_L_V l3
79277: , FV_XLA_AR_REF_V l6
79278: WHERE xet.event_id between x_first_event_id and x_last_event_id
80672:
80673: ELSE null
80674: END source_value
80675: , null source_meaning
80676: FROM xla_events_gt xet
80677: , AR_CASH_RECEIPTS_H_V h2
80678: , AR_RCT_METHOD_H_V h6
80679: , AR_RCT_SITE_USES_H_V h7
80680: , AR_REMIT_BANK_ACCT_H_V h9
80948:
80949: ELSE null
80950: END source_value
80951: , null source_meaning
80952: FROM xla_events_gt xet
80953: , AR_BILL_TO_CUSTOMERS_S_V l1
80954: , AR_CUST_TRX_LINES_L_V l3
80955: , AR_DISTRIBUTIONS_BASE_V l4
80956: , AR_DISTRIBUTIONS_L_V l5
81257: , h2.RCT_DOC_SEQUENCE_CATEGORY source_86
81258: , h2.RCT_DOC_SEQUENCE_ID source_87
81259: , h2.RCT_DOC_SEQUENCE_VALUE source_88
81260: , h2.RCT_TRX_ACCT_REVERSAL source_89
81261: FROM xla_events_gt xet
81262: , AR_CASH_RECEIPTS_H_V h2
81263: , AR_RCT_METHOD_H_V h6
81264: , AR_RCT_SITE_USES_H_V h7
81265: , AR_REMIT_BANK_ACCT_H_V h9
81340: , l5.DIST_ENT_AMT_FROM source_72
81341: , l4.DIST_ACCTD_AMT source_73
81342: , l4.DIST_TO_CUR_CONVERSION_TYPE source_74
81343: , l5.DIST_SOURCE_TABLE source_75
81344: FROM xla_events_gt xet
81345: , AR_BILL_TO_CUSTOMERS_S_V l1
81346: , AR_CUST_TRX_LINES_L_V l3
81347: , AR_DISTRIBUTIONS_BASE_V l4
81348: , AR_DISTRIBUTIONS_L_V l5
84083: ,p_level => C_LEVEL_STATEMENT
84084: ,p_module => l_log_module);
84085:
84086: trace
84087: (p_msg => '# of events in xla_events_gt: '
84088: ||xla_context_pkg.get_event_count_context
84089: ,p_level => C_LEVEL_STATEMENT
84090: ,p_module => l_log_module);
84091: