[Home] [Help]
66790:
66791: ELSE null
66792: END source_value
66793: , null source_meaning
66794: FROM xla_events_gt xet
66795: , AR_ADJUSTMENTS_H_V h1
66796: , AR_BILL_TO_CUSTOMERS_S_V h2
66797: , AR_BILL_TO_SITE_USES_S_V h3
66798: , AR_RECEIVABLES_TRX_ACT_S_V h6
66941:
66942: ELSE null
66943: END source_value
66944: , null source_meaning
66945: FROM xla_events_gt xet
66946: , AR_DISTRIBUTIONS_BASE_V l4
66947: , AR_DISTRIBUTIONS_L_V l5
66948: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
66949: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
67157: , h7.XLA_PARTY_TYPE source_32
67158: , h1.ADJ_DOC_SEQUENCE_CATEGORY source_77
67159: , h1.ADJ_DOC_SEQUENCE_ID source_78
67160: , h1.ADJ_DOC_SEQUENCE_VALUE source_79
67161: FROM xla_events_gt xet
67162: , AR_ADJUSTMENTS_H_V h1
67163: , AR_BILL_TO_CUSTOMERS_S_V h2
67164: , AR_BILL_TO_SITE_USES_S_V h3
67165: , AR_RECEIVABLES_TRX_ACT_S_V h6
67215: , l4.DIST_CUR_CONVERSION_DATE source_26
67216: , l4.DIST_CUR_CONVERSION_RATE source_27
67217: , l4.DIST_CUR_CONVERSION_TYPE source_28
67218: , l4.DIST_TO_ACCTD_AMT source_29
67219: FROM xla_events_gt xet
67220: , AR_DISTRIBUTIONS_BASE_V l4
67221: , AR_DISTRIBUTIONS_L_V l5
67222: WHERE xet.event_id between x_first_event_id and x_last_event_id
67223: and xet.event_date between p_pad_start_date and p_pad_end_date
68241:
68242: ELSE null
68243: END source_value
68244: , null source_meaning
68245: FROM xla_events_gt xet
68246: , AR_BILL_TO_CUSTOMERS_S_V h1
68247: , AR_BILL_TO_SITE_USES_S_V h2
68248: , AR_TRANSACTIONS_S_V h5
68249: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
68383:
68384: ELSE null
68385: END source_value
68386: , null source_meaning
68387: FROM xla_events_gt xet
68388: , AR_CUST_TRX_LINES_BASE_V l3
68389: , AR_CUST_TRX_LINES_L_V l4
68390: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
68391: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68597: , h5.XLA_PARTY_TYPE source_32
68598: , h5.TRX_INVOICE_CURRENCY_CODE source_37
68599: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
68600: , h5.TRX_DOC_SEQUENCE_ID source_82
68601: FROM xla_events_gt xet
68602: , AR_BILL_TO_CUSTOMERS_S_V h1
68603: , AR_BILL_TO_SITE_USES_S_V h2
68604: , AR_TRANSACTIONS_S_V h5
68605: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
68650: , l3.TRX_LINE_CUR_CONVERSION_DATE source_38
68651: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
68652: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
68653: , l3.TRX_LINE_ACCTD_AMT source_41
68654: FROM xla_events_gt xet
68655: , AR_CUST_TRX_LINES_BASE_V l3
68656: , AR_CUST_TRX_LINES_L_V l4
68657: WHERE xet.event_id between x_first_event_id and x_last_event_id
68658: and xet.event_date between p_pad_start_date and p_pad_end_date
69482:
69483: ELSE null
69484: END source_value
69485: , null source_meaning
69486: FROM xla_events_gt xet
69487: , AR_CM_BILL_SITE_USES_H_V h1
69488: , AR_CM_BILL_TO_CUST_H_V h2
69489: , AR_CREDIT_MEMO_H_V h5
69490: , AR_SYSTEM_PARAM_H_V h8
69671:
69672: ELSE null
69673: END source_value
69674: , null source_meaning
69675: FROM xla_events_gt xet
69676: , AR_CM_LINES_BASE_V l3
69677: , AR_CM_LINES_L_V l4
69678: , AR_DISTRIBUTIONS_L_V l6
69679: , AR_RECEIVABLES_TRX_ACT_S_V l7
69909: , h5.XLA_PARTY_TYPE source_32
69910: , h5.CM_INVOICE_CURRENCY_CODE source_44
69911: , h2.CM_BILL_CUST_ACCOUNT_ID source_50
69912: , h1.CM_BILL_USES_SITE_USE_ID source_51
69913: FROM xla_events_gt xet
69914: , AR_CM_BILL_SITE_USES_H_V h1
69915: , AR_CM_BILL_TO_CUST_H_V h2
69916: , AR_CREDIT_MEMO_H_V h5
69917: , AR_SYSTEM_PARAM_H_V h8
69973: , l3.CM_LINE_ACCTD_AMT source_49
69974: , l4.CM_TAX_LINE_ID source_52
69975: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_53
69976: , l4.CM_LINE_DIST_AMT source_54
69977: FROM xla_events_gt xet
69978: , AR_CM_LINES_BASE_V l3
69979: , AR_CM_LINES_L_V l4
69980: , AR_DISTRIBUTIONS_L_V l6
69981: , AR_RECEIVABLES_TRX_ACT_S_V l7
71219:
71220: ELSE null
71221: END source_value
71222: , null source_meaning
71223: FROM xla_events_gt xet
71224: , AR_BILL_TO_CUSTOMERS_S_V h1
71225: , AR_BILL_TO_SITE_USES_S_V h2
71226: , AR_TRANSACTIONS_S_V h5
71227: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
71366:
71367: ELSE null
71368: END source_value
71369: , null source_meaning
71370: FROM xla_events_gt xet
71371: , AR_CUST_TRX_LINES_BASE_V l3
71372: , AR_CUST_TRX_LINES_L_V l4
71373: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
71374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71582: , h5.XLA_PARTY_TYPE source_32
71583: , h5.TRX_INVOICE_CURRENCY_CODE source_37
71584: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
71585: , h5.TRX_DOC_SEQUENCE_ID source_82
71586: FROM xla_events_gt xet
71587: , AR_BILL_TO_CUSTOMERS_S_V h1
71588: , AR_BILL_TO_SITE_USES_S_V h2
71589: , AR_TRANSACTIONS_S_V h5
71590: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
71636: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
71637: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
71638: , l3.TRX_LINE_ACCTD_AMT source_41
71639: , l4.TRX_TAX_LINE_ID source_55
71640: FROM xla_events_gt xet
71641: , AR_CUST_TRX_LINES_BASE_V l3
71642: , AR_CUST_TRX_LINES_L_V l4
71643: WHERE xet.event_id between x_first_event_id and x_last_event_id
71644: and xet.event_date between p_pad_start_date and p_pad_end_date
72700:
72701: ELSE null
72702: END source_value
72703: , null source_meaning
72704: FROM xla_events_gt xet
72705: , AR_BILL_TO_CUSTOMERS_S_V h1
72706: , AR_BILL_TO_SITE_USES_S_V h2
72707: , AR_TRANSACTIONS_S_V h5
72708: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
72842:
72843: ELSE null
72844: END source_value
72845: , null source_meaning
72846: FROM xla_events_gt xet
72847: , AR_CUST_TRX_LINES_BASE_V l3
72848: , AR_CUST_TRX_LINES_L_V l4
72849: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72850: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73056: , h5.XLA_PARTY_TYPE source_32
73057: , h5.TRX_INVOICE_CURRENCY_CODE source_37
73058: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
73059: , h5.TRX_DOC_SEQUENCE_ID source_82
73060: FROM xla_events_gt xet
73061: , AR_BILL_TO_CUSTOMERS_S_V h1
73062: , AR_BILL_TO_SITE_USES_S_V h2
73063: , AR_TRANSACTIONS_S_V h5
73064: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73109: , l3.TRX_LINE_CUR_CONVERSION_DATE source_38
73110: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
73111: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
73112: , l3.TRX_LINE_ACCTD_AMT source_41
73113: FROM xla_events_gt xet
73114: , AR_CUST_TRX_LINES_BASE_V l3
73115: , AR_CUST_TRX_LINES_L_V l4
73116: WHERE xet.event_id between x_first_event_id and x_last_event_id
73117: and xet.event_date between p_pad_start_date and p_pad_end_date
73946:
73947: ELSE null
73948: END source_value
73949: , null source_meaning
73950: FROM xla_events_gt xet
73951: , AR_BILL_TO_CUSTOMERS_S_V h1
73952: , AR_BILL_TO_SITE_USES_S_V h2
73953: , AR_TRANSACTIONS_S_V h5
73954: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
74088:
74089: ELSE null
74090: END source_value
74091: , null source_meaning
74092: FROM xla_events_gt xet
74093: , AR_CUST_TRX_LINES_BASE_V l3
74094: , AR_CUST_TRX_LINES_L_V l4
74095: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74096: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74302: , h5.XLA_PARTY_TYPE source_32
74303: , h5.TRX_INVOICE_CURRENCY_CODE source_37
74304: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
74305: , h5.TRX_DOC_SEQUENCE_ID source_82
74306: FROM xla_events_gt xet
74307: , AR_BILL_TO_CUSTOMERS_S_V h1
74308: , AR_BILL_TO_SITE_USES_S_V h2
74309: , AR_TRANSACTIONS_S_V h5
74310: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74355: , l3.TRX_LINE_CUR_CONVERSION_DATE source_38
74356: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
74357: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
74358: , l3.TRX_LINE_ACCTD_AMT source_41
74359: FROM xla_events_gt xet
74360: , AR_CUST_TRX_LINES_BASE_V l3
74361: , AR_CUST_TRX_LINES_L_V l4
74362: WHERE xet.event_id between x_first_event_id and x_last_event_id
74363: and xet.event_date between p_pad_start_date and p_pad_end_date
75202:
75203: ELSE null
75204: END source_value
75205: , null source_meaning
75206: FROM xla_events_gt xet
75207: , AR_BILL_TO_CUSTOMERS_S_V h1
75208: , AR_BILL_TO_SITE_USES_S_V h2
75209: , AR_TRANSACTIONS_S_V h5
75210: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75364:
75365: ELSE null
75366: END source_value
75367: , null source_meaning
75368: FROM xla_events_gt xet
75369: , AR_CUST_TRX_LINES_BASE_V l3
75370: , AR_CUST_TRX_LINES_L_V l4
75371: , FV_XLA_AR_REF_V l6
75372: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
75593: , h5.XLA_PARTY_TYPE source_32
75594: , h5.TRX_INVOICE_CURRENCY_CODE source_37
75595: , h5.TRX_DOC_SEQUENCE_CATEGORY source_81
75596: , h5.TRX_DOC_SEQUENCE_ID source_82
75597: FROM xla_events_gt xet
75598: , AR_BILL_TO_CUSTOMERS_S_V h1
75599: , AR_BILL_TO_SITE_USES_S_V h2
75600: , AR_TRANSACTIONS_S_V h5
75601: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75650: , l3.TRX_LINE_ACCTD_AMT source_41
75651: , l4.TRX_TAX_LINE_ID source_55
75652: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_56
75653: , l3.ROUNDING_CORRECTION_FLAG source_66
75654: FROM xla_events_gt xet
75655: , AR_CUST_TRX_LINES_BASE_V l3
75656: , AR_CUST_TRX_LINES_L_V l4
75657: , FV_XLA_AR_REF_V l6
75658: WHERE xet.event_id between x_first_event_id and x_last_event_id
76879:
76880: ELSE null
76881: END source_value
76882: , null source_meaning
76883: FROM xla_events_gt xet
76884: , AR_CASH_RECEIPTS_H_V h1
76885: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
76886: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76887: AND xet.event_class_code = C_EVENT_CLASS_CODE
77056:
77057: ELSE null
77058: END source_value
77059: , null source_meaning
77060: FROM xla_events_gt xet
77061: , AR_DISTRIBUTIONS_BASE_V l2
77062: , AR_DISTRIBUTIONS_L_V l3
77063: , FV_XLA_AR_REF_V l4
77064: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77278: , h1.RCT_DOC_SEQUENCE_CATEGORY source_83
77279: , h1.RCT_DOC_SEQUENCE_ID source_84
77280: , h1.RCT_DOC_SEQUENCE_VALUE source_85
77281: , h1.RCT_TRX_ACCT_REVERSAL source_86
77282: FROM xla_events_gt xet
77283: , AR_CASH_RECEIPTS_H_V h1
77284: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
77285: and xet.event_class_code = C_EVENT_CLASS_CODE
77286: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id
77335: , l2.DIST_TO_ACCTD_AMT source_29
77336: , l4.FEDERAL_ACCOUNT_VALID_FLAG source_56
77337: , l2.DIST_TO_CUR_CONVERSION_DATE source_57
77338: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_67
77339: FROM xla_events_gt xet
77340: , AR_DISTRIBUTIONS_BASE_V l2
77341: , AR_DISTRIBUTIONS_L_V l3
77342: , FV_XLA_AR_REF_V l4
77343: WHERE xet.event_id between x_first_event_id and x_last_event_id
78636:
78637: ELSE null
78638: END source_value
78639: , null source_meaning
78640: FROM xla_events_gt xet
78641: , AR_CASH_RECEIPTS_H_V h2
78642: , AR_RCT_SITE_USES_H_V h6
78643: , AR_REMIT_BANK_ACCT_H_V h8
78644: , AR_SYSTEM_PARAM_H_V h9
78925:
78926: ELSE null
78927: END source_value
78928: , null source_meaning
78929: FROM xla_events_gt xet
78930: , AR_BILL_TO_CUSTOMERS_S_V l1
78931: , AR_CUST_TRX_LINES_L_V l3
78932: , AR_DISTRIBUTIONS_BASE_V l4
78933: , AR_DISTRIBUTIONS_L_V l5
79231: , h2.RCT_DOC_SEQUENCE_CATEGORY source_83
79232: , h2.RCT_DOC_SEQUENCE_ID source_84
79233: , h2.RCT_DOC_SEQUENCE_VALUE source_85
79234: , h2.RCT_TRX_ACCT_REVERSAL source_86
79235: FROM xla_events_gt xet
79236: , AR_CASH_RECEIPTS_H_V h2
79237: , AR_RCT_SITE_USES_H_V h6
79238: , AR_REMIT_BANK_ACCT_H_V h8
79239: , AR_SYSTEM_PARAM_H_V h9
79315: , l5.DIST_ENT_AMT_FROM source_68
79316: , l4.DIST_ACCTD_AMT source_69
79317: , l4.DIST_TO_CUR_CONVERSION_TYPE source_70
79318: , l5.DIST_SOURCE_TABLE source_71
79319: FROM xla_events_gt xet
79320: , AR_BILL_TO_CUSTOMERS_S_V l1
79321: , AR_CUST_TRX_LINES_L_V l3
79322: , AR_DISTRIBUTIONS_BASE_V l4
79323: , AR_DISTRIBUTIONS_L_V l5
81830: ,p_level => C_LEVEL_STATEMENT
81831: ,p_module => l_log_module);
81832:
81833: trace
81834: (p_msg => '# of events in xla_events_gt: '
81835: ||xla_context_pkg.get_event_count_context
81836: ,p_level => C_LEVEL_STATEMENT
81837: ,p_module => l_log_module);
81838: