[Home] [Help]
67756:
67757: ELSE null
67758: END source_value
67759: , null source_meaning
67760: FROM xla_events_gt xet
67761: , AR_ADJUSTMENTS_H_V h1
67762: , AR_BILL_TO_CUSTOMERS_S_V h2
67763: , AR_BILL_TO_SITE_USES_S_V h3
67764: , AR_RECEIVABLES_TRX_ACT_S_V h6
67907:
67908: ELSE null
67909: END source_value
67910: , null source_meaning
67911: FROM xla_events_gt xet
67912: , AR_DISTRIBUTIONS_BASE_V l4
67913: , AR_DISTRIBUTIONS_L_V l5
67914: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
67915: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68126: , h7.XLA_PARTY_TYPE source_34
68127: , h1.ADJ_DOC_SEQUENCE_CATEGORY source_81
68128: , h1.ADJ_DOC_SEQUENCE_ID source_82
68129: , h1.ADJ_DOC_SEQUENCE_VALUE source_83
68130: FROM xla_events_gt xet
68131: , AR_ADJUSTMENTS_H_V h1
68132: , AR_BILL_TO_CUSTOMERS_S_V h2
68133: , AR_BILL_TO_SITE_USES_S_V h3
68134: , AR_RECEIVABLES_TRX_ACT_S_V h6
68184: , l4.DIST_CUR_CONVERSION_DATE source_28
68185: , l4.DIST_CUR_CONVERSION_RATE source_29
68186: , l4.DIST_CUR_CONVERSION_TYPE source_30
68187: , l4.DIST_TO_ACCTD_AMT source_31
68188: FROM xla_events_gt xet
68189: , AR_DISTRIBUTIONS_BASE_V l4
68190: , AR_DISTRIBUTIONS_L_V l5
68191: WHERE xet.event_id between x_first_event_id and x_last_event_id
68192: and xet.event_date between p_pad_start_date and p_pad_end_date
69121:
69122: ELSE null
69123: END source_value
69124: , null source_meaning
69125: FROM xla_events_gt xet
69126: , AR_BILL_TO_CUSTOMERS_S_V h1
69127: , AR_BILL_TO_SITE_USES_S_V h2
69128: , AR_TRANSACTIONS_S_V h5
69129: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
69263:
69264: ELSE null
69265: END source_value
69266: , null source_meaning
69267: FROM xla_events_gt xet
69268: , AR_CUST_TRX_LINES_BASE_V l3
69269: , AR_CUST_TRX_LINES_L_V l4
69270: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69271: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69477: , h5.TRX_INVOICE_CURRENCY_CODE source_39
69478: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
69479: , h5.TRX_DOC_SEQUENCE_ID source_86
69480: , h5.TRX_DOC_SEQUENCE_VALUE source_87
69481: FROM xla_events_gt xet
69482: , AR_BILL_TO_CUSTOMERS_S_V h1
69483: , AR_BILL_TO_SITE_USES_S_V h2
69484: , AR_TRANSACTIONS_S_V h5
69485: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
69530: , l3.TRX_LINE_CUR_CONVERSION_DATE source_40
69531: , l3.TRX_LINE_CUR_CONVERSION_RATE source_41
69532: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
69533: , l3.TRX_LINE_ACCTD_AMT source_43
69534: FROM xla_events_gt xet
69535: , AR_CUST_TRX_LINES_BASE_V l3
69536: , AR_CUST_TRX_LINES_L_V l4
69537: WHERE xet.event_id between x_first_event_id and x_last_event_id
69538: and xet.event_date between p_pad_start_date and p_pad_end_date
70372:
70373: ELSE null
70374: END source_value
70375: , null source_meaning
70376: FROM xla_events_gt xet
70377: , AR_CM_BILL_SITE_USES_H_V h1
70378: , AR_CM_BILL_TO_CUST_H_V h2
70379: , AR_CREDIT_MEMO_H_V h5
70380: , AR_SYSTEM_PARAM_H_V h8
70546:
70547: ELSE null
70548: END source_value
70549: , null source_meaning
70550: FROM xla_events_gt xet
70551: , AR_CM_LINES_BASE_V l3
70552: , AR_CM_LINES_L_V l4
70553: , AR_DISTRIBUTIONS_L_V l6
70554: , AR_RECEIVABLES_TRX_ACT_S_V l7
70781: , h5.CM_INVOICE_CURRENCY_CODE source_46
70782: , h2.CM_BILL_CUST_ACCOUNT_ID source_52
70783: , h1.CM_BILL_USES_SITE_USE_ID source_53
70784: , h5.CM_INVOICING_RULE_ID source_69
70785: FROM xla_events_gt xet
70786: , AR_CM_BILL_SITE_USES_H_V h1
70787: , AR_CM_BILL_TO_CUST_H_V h2
70788: , AR_CREDIT_MEMO_H_V h5
70789: , AR_SYSTEM_PARAM_H_V h8
70842: , l3.CM_LINE_ACCTD_AMT source_51
70843: , l4.CM_TAX_LINE_ID source_54
70844: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_55
70845: , l4.CM_LINE_DIST_AMT source_56
70846: FROM xla_events_gt xet
70847: , AR_CM_LINES_BASE_V l3
70848: , AR_CM_LINES_L_V l4
70849: , AR_DISTRIBUTIONS_L_V l6
70850: , AR_RECEIVABLES_TRX_ACT_S_V l7
71996:
71997: ELSE null
71998: END source_value
71999: , null source_meaning
72000: FROM xla_events_gt xet
72001: , AR_BILL_TO_CUSTOMERS_S_V h1
72002: , AR_BILL_TO_SITE_USES_S_V h2
72003: , AR_TRANSACTIONS_S_V h5
72004: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72143:
72144: ELSE null
72145: END source_value
72146: , null source_meaning
72147: FROM xla_events_gt xet
72148: , AR_CUST_TRX_LINES_BASE_V l3
72149: , AR_CUST_TRX_LINES_L_V l4
72150: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
72151: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72365: , h5.TRX_INVOICING_RULE_ID source_70
72366: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
72367: , h5.TRX_DOC_SEQUENCE_ID source_86
72368: , h5.TRX_DOC_SEQUENCE_VALUE source_87
72369: FROM xla_events_gt xet
72370: , AR_BILL_TO_CUSTOMERS_S_V h1
72371: , AR_BILL_TO_SITE_USES_S_V h2
72372: , AR_TRANSACTIONS_S_V h5
72373: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72419: , l3.TRX_LINE_CUR_CONVERSION_RATE source_41
72420: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
72421: , l3.TRX_LINE_ACCTD_AMT source_43
72422: , l4.TRX_TAX_LINE_ID source_57
72423: FROM xla_events_gt xet
72424: , AR_CUST_TRX_LINES_BASE_V l3
72425: , AR_CUST_TRX_LINES_L_V l4
72426: WHERE xet.event_id between x_first_event_id and x_last_event_id
72427: and xet.event_date between p_pad_start_date and p_pad_end_date
73457:
73458: ELSE null
73459: END source_value
73460: , null source_meaning
73461: FROM xla_events_gt xet
73462: , AR_BILL_TO_CUSTOMERS_S_V h1
73463: , AR_BILL_TO_SITE_USES_S_V h2
73464: , AR_TRANSACTIONS_S_V h5
73465: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
73599:
73600: ELSE null
73601: END source_value
73602: , null source_meaning
73603: FROM xla_events_gt xet
73604: , AR_CUST_TRX_LINES_BASE_V l3
73605: , AR_CUST_TRX_LINES_L_V l4
73606: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
73607: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73813: , h5.TRX_INVOICE_CURRENCY_CODE source_39
73814: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
73815: , h5.TRX_DOC_SEQUENCE_ID source_86
73816: , h5.TRX_DOC_SEQUENCE_VALUE source_87
73817: FROM xla_events_gt xet
73818: , AR_BILL_TO_CUSTOMERS_S_V h1
73819: , AR_BILL_TO_SITE_USES_S_V h2
73820: , AR_TRANSACTIONS_S_V h5
73821: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
73866: , l3.TRX_LINE_CUR_CONVERSION_DATE source_40
73867: , l3.TRX_LINE_CUR_CONVERSION_RATE source_41
73868: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
73869: , l3.TRX_LINE_ACCTD_AMT source_43
73870: FROM xla_events_gt xet
73871: , AR_CUST_TRX_LINES_BASE_V l3
73872: , AR_CUST_TRX_LINES_L_V l4
73873: WHERE xet.event_id between x_first_event_id and x_last_event_id
73874: and xet.event_date between p_pad_start_date and p_pad_end_date
74703:
74704: ELSE null
74705: END source_value
74706: , null source_meaning
74707: FROM xla_events_gt xet
74708: , AR_BILL_TO_CUSTOMERS_S_V h1
74709: , AR_BILL_TO_SITE_USES_S_V h2
74710: , AR_TRANSACTIONS_S_V h5
74711: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
74845:
74846: ELSE null
74847: END source_value
74848: , null source_meaning
74849: FROM xla_events_gt xet
74850: , AR_CUST_TRX_LINES_BASE_V l3
74851: , AR_CUST_TRX_LINES_L_V l4
74852: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74853: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75059: , h5.TRX_INVOICE_CURRENCY_CODE source_39
75060: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
75061: , h5.TRX_DOC_SEQUENCE_ID source_86
75062: , h5.TRX_DOC_SEQUENCE_VALUE source_87
75063: FROM xla_events_gt xet
75064: , AR_BILL_TO_CUSTOMERS_S_V h1
75065: , AR_BILL_TO_SITE_USES_S_V h2
75066: , AR_TRANSACTIONS_S_V h5
75067: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75112: , l3.TRX_LINE_CUR_CONVERSION_DATE source_40
75113: , l3.TRX_LINE_CUR_CONVERSION_RATE source_41
75114: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
75115: , l3.TRX_LINE_ACCTD_AMT source_43
75116: FROM xla_events_gt xet
75117: , AR_CUST_TRX_LINES_BASE_V l3
75118: , AR_CUST_TRX_LINES_L_V l4
75119: WHERE xet.event_id between x_first_event_id and x_last_event_id
75120: and xet.event_date between p_pad_start_date and p_pad_end_date
75964:
75965: ELSE null
75966: END source_value
75967: , null source_meaning
75968: FROM xla_events_gt xet
75969: , AR_BILL_TO_CUSTOMERS_S_V h1
75970: , AR_BILL_TO_SITE_USES_S_V h2
75971: , AR_TRANSACTIONS_S_V h5
75972: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
76126:
76127: ELSE null
76128: END source_value
76129: , null source_meaning
76130: FROM xla_events_gt xet
76131: , AR_CUST_TRX_LINES_BASE_V l3
76132: , AR_CUST_TRX_LINES_L_V l4
76133: , FV_XLA_AR_REF_V l6
76134: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
76358: , h5.TRX_INVOICING_RULE_ID source_70
76359: , h5.TRX_DOC_SEQUENCE_CATEGORY source_85
76360: , h5.TRX_DOC_SEQUENCE_ID source_86
76361: , h5.TRX_DOC_SEQUENCE_VALUE source_87
76362: FROM xla_events_gt xet
76363: , AR_BILL_TO_CUSTOMERS_S_V h1
76364: , AR_BILL_TO_SITE_USES_S_V h2
76365: , AR_TRANSACTIONS_S_V h5
76366: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76415: , l3.TRX_LINE_ACCTD_AMT source_43
76416: , l4.TRX_TAX_LINE_ID source_57
76417: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_58
76418: , l3.ROUNDING_CORRECTION_FLAG source_68
76419: FROM xla_events_gt xet
76420: , AR_CUST_TRX_LINES_BASE_V l3
76421: , AR_CUST_TRX_LINES_L_V l4
76422: , FV_XLA_AR_REF_V l6
76423: WHERE xet.event_id between x_first_event_id and x_last_event_id
77547:
77548: ELSE null
77549: END source_value
77550: , null source_meaning
77551: FROM xla_events_gt xet
77552: , AR_CASH_RECEIPTS_H_V h1
77553: , AR_RCT_METHOD_H_V h4
77554: , AR_REMIT_BANK_ACCT_H_V h5
77555: ,(select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
77726:
77727: ELSE null
77728: END source_value
77729: , null source_meaning
77730: FROM xla_events_gt xet
77731: , AR_DISTRIBUTIONS_BASE_V l2
77732: , AR_DISTRIBUTIONS_L_V l3
77733: , FV_XLA_AR_REF_V l6
77734: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77966: , h1.RCT_DOC_SEQUENCE_CATEGORY source_88
77967: , h1.RCT_DOC_SEQUENCE_ID source_89
77968: , h1.RCT_DOC_SEQUENCE_VALUE source_90
77969: , h1.RCT_TRX_ACCT_REVERSAL source_91
77970: FROM xla_events_gt xet
77971: , AR_CASH_RECEIPTS_H_V h1
77972: , AR_RCT_METHOD_H_V h4
77973: , AR_REMIT_BANK_ACCT_H_V h5
77974: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
78027: , l2.DIST_TO_ACCTD_AMT source_31
78028: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_58
78029: , l2.DIST_TO_CUR_CONVERSION_DATE source_59
78030: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_71
78031: FROM xla_events_gt xet
78032: , AR_DISTRIBUTIONS_BASE_V l2
78033: , AR_DISTRIBUTIONS_L_V l3
78034: , FV_XLA_AR_REF_V l6
78035: WHERE xet.event_id between x_first_event_id and x_last_event_id
79431:
79432: ELSE null
79433: END source_value
79434: , null source_meaning
79435: FROM xla_events_gt xet
79436: , AR_CASH_RECEIPTS_H_V h2
79437: , AR_RCT_METHOD_H_V h6
79438: , AR_RCT_SITE_USES_H_V h7
79439: , AR_REMIT_BANK_ACCT_H_V h9
79707:
79708: ELSE null
79709: END source_value
79710: , null source_meaning
79711: FROM xla_events_gt xet
79712: , AR_BILL_TO_CUSTOMERS_S_V l1
79713: , AR_CUST_TRX_LINES_L_V l3
79714: , AR_DISTRIBUTIONS_BASE_V l4
79715: , AR_DISTRIBUTIONS_L_V l5
80022: , h2.RCT_DOC_SEQUENCE_CATEGORY source_88
80023: , h2.RCT_DOC_SEQUENCE_ID source_89
80024: , h2.RCT_DOC_SEQUENCE_VALUE source_90
80025: , h2.RCT_TRX_ACCT_REVERSAL source_91
80026: FROM xla_events_gt xet
80027: , AR_CASH_RECEIPTS_H_V h2
80028: , AR_RCT_METHOD_H_V h6
80029: , AR_RCT_SITE_USES_H_V h7
80030: , AR_REMIT_BANK_ACCT_H_V h9
80105: , l5.DIST_ENT_AMT_FROM source_74
80106: , l4.DIST_ACCTD_AMT source_75
80107: , l4.DIST_TO_CUR_CONVERSION_TYPE source_76
80108: , l5.DIST_SOURCE_TABLE source_77
80109: FROM xla_events_gt xet
80110: , AR_BILL_TO_CUSTOMERS_S_V l1
80111: , AR_CUST_TRX_LINES_L_V l3
80112: , AR_DISTRIBUTIONS_BASE_V l4
80113: , AR_DISTRIBUTIONS_L_V l5
82880: ,p_level => C_LEVEL_STATEMENT
82881: ,p_module => l_log_module);
82882:
82883: trace
82884: (p_msg => '# of events in xla_events_gt: '
82885: ||xla_context_pkg.get_event_count_context
82886: ,p_level => C_LEVEL_STATEMENT
82887: ,p_module => l_log_module);
82888: