[Home] [Help]
63101:
63102: ELSE null
63103: END source_value
63104: , null source_meaning
63105: FROM xla_events_gt xet
63106: , AR_ADJUSTMENTS_H_V h1
63107: , AR_BILL_TO_CUSTOMERS_S_V h2
63108: , AR_BILL_TO_SITE_USES_S_V h3
63109: , AR_RECEIVABLES_TRX_ACT_S_V h6
63252:
63253: ELSE null
63254: END source_value
63255: , null source_meaning
63256: FROM xla_events_gt xet
63257: , AR_DISTRIBUTIONS_BASE_V l4
63258: , AR_DISTRIBUTIONS_L_V l5
63259: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
63260: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
63468: , h7.XLA_PARTY_TYPE source_39
63469: , h1.ADJ_DOC_SEQUENCE_CATEGORY source_107
63470: , h1.ADJ_DOC_SEQUENCE_ID source_108
63471: , h1.ADJ_DOC_SEQUENCE_VALUE source_109
63472: FROM xla_events_gt xet
63473: , AR_ADJUSTMENTS_H_V h1
63474: , AR_BILL_TO_CUSTOMERS_S_V h2
63475: , AR_BILL_TO_SITE_USES_S_V h3
63476: , AR_RECEIVABLES_TRX_ACT_S_V h6
63526: , l4.DIST_CUR_CONVERSION_DATE source_33
63527: , l4.DIST_CUR_CONVERSION_RATE source_34
63528: , l4.DIST_CUR_CONVERSION_TYPE source_35
63529: , l4.DIST_TO_ACCTD_AMT source_36
63530: FROM xla_events_gt xet
63531: , AR_DISTRIBUTIONS_BASE_V l4
63532: , AR_DISTRIBUTIONS_L_V l5
63533: WHERE xet.event_id between x_first_event_id and x_last_event_id
63534: and xet.event_date between p_pad_start_date and p_pad_end_date
64542:
64543: ELSE null
64544: END source_value
64545: , null source_meaning
64546: FROM xla_events_gt xet
64547: , AR_DRAWEE_CUSTOMERS_H_V h3
64548: , AR_DRAWEE_SITE_USES_H_V h4
64549: , AR_SYSTEM_PARAM_H_V h5
64550: , AR_TRANSACTIONS_S_V h6
64691:
64692: ELSE null
64693: END source_value
64694: , null source_meaning
64695: FROM xla_events_gt xet
64696: , AR_DISTRIBUTIONS_BASE_V l1
64697: , AR_DISTRIBUTIONS_L_V l2
64698: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
64699: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64901: , h5.CODE_COMBINATION_ID_LOSS source_25
64902: , h6.XLA_PARTY_TYPE source_39
64903: , h3.DRAW_CUST_ACCOUNT_ID source_41
64904: , h4.DRAW_SITE_SITE_USE_ID source_42
64905: FROM xla_events_gt xet
64906: , AR_DRAWEE_CUSTOMERS_H_V h3
64907: , AR_DRAWEE_SITE_USES_H_V h4
64908: , AR_SYSTEM_PARAM_H_V h5
64909: , AR_TRANSACTIONS_S_V h6
64957: , l1.DIST_CUR_CONVERSION_DATE source_33
64958: , l1.DIST_CUR_CONVERSION_RATE source_34
64959: , l1.DIST_CUR_CONVERSION_TYPE source_35
64960: , l1.DIST_ACCTD_AMT source_40
64961: FROM xla_events_gt xet
64962: , AR_DISTRIBUTIONS_BASE_V l1
64963: , AR_DISTRIBUTIONS_L_V l2
64964: WHERE xet.event_id between x_first_event_id and x_last_event_id
64965: and xet.event_date between p_pad_start_date and p_pad_end_date
65909:
65910: ELSE null
65911: END source_value
65912: , null source_meaning
65913: FROM xla_events_gt xet
65914: , AR_BILL_TO_CUSTOMERS_S_V h1
65915: , AR_BILL_TO_SITE_USES_S_V h2
65916: , AR_TRANSACTIONS_S_V h5
65917: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
66051:
66052: ELSE null
66053: END source_value
66054: , null source_meaning
66055: FROM xla_events_gt xet
66056: , AR_CUST_TRX_LINES_BASE_V l3
66057: , AR_CUST_TRX_LINES_L_V l4
66058: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
66059: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
66265: , h5.XLA_PARTY_TYPE source_39
66266: , h5.TRX_INVOICE_CURRENCY_CODE source_47
66267: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
66268: , h5.TRX_DOC_SEQUENCE_ID source_112
66269: FROM xla_events_gt xet
66270: , AR_BILL_TO_CUSTOMERS_S_V h1
66271: , AR_BILL_TO_SITE_USES_S_V h2
66272: , AR_TRANSACTIONS_S_V h5
66273: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
66318: , l3.TRX_LINE_CUR_CONVERSION_DATE source_48
66319: , l3.TRX_LINE_CUR_CONVERSION_RATE source_49
66320: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_50
66321: , l3.TRX_LINE_ACCTD_AMT source_51
66322: FROM xla_events_gt xet
66323: , AR_CUST_TRX_LINES_BASE_V l3
66324: , AR_CUST_TRX_LINES_L_V l4
66325: WHERE xet.event_id between x_first_event_id and x_last_event_id
66326: and xet.event_date between p_pad_start_date and p_pad_end_date
67179: WHEN 11 THEN fvl116.meaning
67180:
67181: ELSE null
67182: END source_meaning
67183: FROM xla_events_gt xet
67184: , AR_BILL_TO_CUSTOMERS_S_V h1
67185: , AR_BILL_TO_SITE_USES_S_V h2
67186: , AR_TRANSACTIONS_S_V h3
67187: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
67400: WHEN 22 THEN fvl85.meaning
67401:
67402: ELSE null
67403: END source_meaning
67404: FROM xla_events_gt xet
67405: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67406: , fnd_lookup_values fvl7
67407: , fnd_lookup_values fvl66
67408: , fnd_lookup_values fvl67
67675: , h5.JLBR_EXCHG_LOSS_CCID source_114
67676: , h5.JLBR_GL_DATE source_115
67677: , h5.JLBR_TRANSFER_TO_GL_FLAG source_116
67678: , fvl116.meaning source_116_meaning
67679: FROM xla_events_gt xet
67680: , AR_BILL_TO_CUSTOMERS_S_V h1
67681: , AR_BILL_TO_SITE_USES_S_V h2
67682: , AR_TRANSACTIONS_S_V h3
67683: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
67752: , l4.JLBR_REVERSED_DIST_ID source_83
67753: , l4.JLBR_REVERSED_DIST_LINK_TYPE source_84
67754: , l4.JLBR_BANK_OCC_TYPE source_85
67755: , fvl85.meaning source_85_meaning
67756: FROM xla_events_gt xet
67757: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
67758: , fnd_lookup_values fvl7
67759: , fnd_lookup_values fvl66
67760: , fnd_lookup_values fvl67
68835:
68836: ELSE null
68837: END source_value
68838: , null source_meaning
68839: FROM xla_events_gt xet
68840: , AR_CM_BILL_SITE_USES_H_V h1
68841: , AR_CM_BILL_TO_CUST_H_V h2
68842: , AR_CREDIT_MEMO_H_V h5
68843: , AR_SYSTEM_PARAM_H_V h9
69029:
69030: ELSE null
69031: END source_value
69032: , null source_meaning
69033: FROM xla_events_gt xet
69034: , AR_CM_LINES_BASE_V l3
69035: , AR_CM_LINES_L_V l4
69036: , AR_CUST_TRX_LINES_L_V l6
69037: , AR_DISTRIBUTIONS_L_V l7
69272: , h5.XLA_PARTY_TYPE source_39
69273: , h5.CM_INVOICE_CURRENCY_CODE source_54
69274: , h2.CM_BILL_CUST_ACCOUNT_ID source_60
69275: , h1.CM_BILL_USES_SITE_USE_ID source_61
69276: FROM xla_events_gt xet
69277: , AR_CM_BILL_SITE_USES_H_V h1
69278: , AR_CM_BILL_TO_CUST_H_V h2
69279: , AR_CREDIT_MEMO_H_V h5
69280: , AR_SYSTEM_PARAM_H_V h9
69337: , l4.CM_TAX_LINE_ID source_62
69338: , l4.CM_LINE_DIST_ACCOUNT_CLASS source_63
69339: , l4.CM_LINE_DIST_AMT source_64
69340: , l6.TRX_LINE_INTERFACE_LINE_ATTR1 source_65
69341: FROM xla_events_gt xet
69342: , AR_CM_LINES_BASE_V l3
69343: , AR_CM_LINES_L_V l4
69344: , AR_CUST_TRX_LINES_L_V l6
69345: , AR_DISTRIBUTIONS_L_V l7
70556:
70557: ELSE null
70558: END source_value
70559: , null source_meaning
70560: FROM xla_events_gt xet
70561: , AR_BILL_TO_CUSTOMERS_S_V h1
70562: , AR_BILL_TO_SITE_USES_S_V h2
70563: , AR_TRANSACTIONS_S_V h5
70564: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
70708:
70709: ELSE null
70710: END source_value
70711: , null source_meaning
70712: FROM xla_events_gt xet
70713: , AR_CUST_TRX_LINES_BASE_V l3
70714: , AR_CUST_TRX_LINES_L_V l4
70715: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
70716: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70926: , h5.XLA_PARTY_TYPE source_39
70927: , h5.TRX_INVOICE_CURRENCY_CODE source_47
70928: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
70929: , h5.TRX_DOC_SEQUENCE_ID source_112
70930: FROM xla_events_gt xet
70931: , AR_BILL_TO_CUSTOMERS_S_V h1
70932: , AR_BILL_TO_SITE_USES_S_V h2
70933: , AR_TRANSACTIONS_S_V h5
70934: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
70981: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_50
70982: , l3.TRX_LINE_ACCTD_AMT source_51
70983: , l4.TRX_LINE_INTERFACE_LINE_ATTR1 source_65
70984: , l4.TRX_TAX_LINE_ID source_86
70985: FROM xla_events_gt xet
70986: , AR_CUST_TRX_LINES_BASE_V l3
70987: , AR_CUST_TRX_LINES_L_V l4
70988: WHERE xet.event_id between x_first_event_id and x_last_event_id
70989: and xet.event_date between p_pad_start_date and p_pad_end_date
72016:
72017: ELSE null
72018: END source_value
72019: , null source_meaning
72020: FROM xla_events_gt xet
72021: , AR_BILL_TO_CUSTOMERS_S_V h1
72022: , AR_BILL_TO_SITE_USES_S_V h2
72023: , AR_TRANSACTIONS_S_V h5
72024: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
72158:
72159: ELSE null
72160: END source_value
72161: , null source_meaning
72162: FROM xla_events_gt xet
72163: , AR_CUST_TRX_LINES_BASE_V l3
72164: , AR_CUST_TRX_LINES_L_V l4
72165: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72166: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72372: , h5.XLA_PARTY_TYPE source_39
72373: , h5.TRX_INVOICE_CURRENCY_CODE source_47
72374: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
72375: , h5.TRX_DOC_SEQUENCE_ID source_112
72376: FROM xla_events_gt xet
72377: , AR_BILL_TO_CUSTOMERS_S_V h1
72378: , AR_BILL_TO_SITE_USES_S_V h2
72379: , AR_TRANSACTIONS_S_V h5
72380: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
72425: , l3.TRX_LINE_CUR_CONVERSION_DATE source_48
72426: , l3.TRX_LINE_CUR_CONVERSION_RATE source_49
72427: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_50
72428: , l3.TRX_LINE_ACCTD_AMT source_51
72429: FROM xla_events_gt xet
72430: , AR_CUST_TRX_LINES_BASE_V l3
72431: , AR_CUST_TRX_LINES_L_V l4
72432: WHERE xet.event_id between x_first_event_id and x_last_event_id
72433: and xet.event_date between p_pad_start_date and p_pad_end_date
73286: WHEN 11 THEN fvl116.meaning
73287:
73288: ELSE null
73289: END source_meaning
73290: FROM xla_events_gt xet
73291: , AR_BILL_TO_CUSTOMERS_S_V h1
73292: , AR_BILL_TO_SITE_USES_S_V h2
73293: , AR_TRANSACTIONS_S_V h3
73294: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
73512: WHEN 23 THEN fvl85.meaning
73513:
73514: ELSE null
73515: END source_meaning
73516: FROM xla_events_gt xet
73517: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73518: , fnd_lookup_values fvl7
73519: , fnd_lookup_values fvl66
73520: , fnd_lookup_values fvl67
73789: , h5.JLBR_EXCHG_LOSS_CCID source_114
73790: , h5.JLBR_GL_DATE source_115
73791: , h5.JLBR_TRANSFER_TO_GL_FLAG source_116
73792: , fvl116.meaning source_116_meaning
73793: FROM xla_events_gt xet
73794: , AR_BILL_TO_CUSTOMERS_S_V h1
73795: , AR_BILL_TO_SITE_USES_S_V h2
73796: , AR_TRANSACTIONS_S_V h3
73797: , JL_BR_AR_COLL_OCC_DOCS_H_V h5
73867: , l4.JLBR_REVERSED_DIST_ID source_83
73868: , l4.JLBR_REVERSED_DIST_LINK_TYPE source_84
73869: , l4.JLBR_BANK_OCC_TYPE source_85
73870: , fvl85.meaning source_85_meaning
73871: FROM xla_events_gt xet
73872: , JL_BR_AR_COLL_DOC_DISTS_L_V l4
73873: , fnd_lookup_values fvl7
73874: , fnd_lookup_values fvl66
73875: , fnd_lookup_values fvl67
75002:
75003: ELSE null
75004: END source_value
75005: , null source_meaning
75006: FROM xla_events_gt xet
75007: , AR_BILL_TO_CUSTOMERS_S_V h1
75008: , AR_BILL_TO_SITE_USES_S_V h2
75009: , AR_TRANSACTIONS_S_V h5
75010: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
75144:
75145: ELSE null
75146: END source_value
75147: , null source_meaning
75148: FROM xla_events_gt xet
75149: , AR_CUST_TRX_LINES_BASE_V l3
75150: , AR_CUST_TRX_LINES_L_V l4
75151: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75152: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75358: , h5.XLA_PARTY_TYPE source_39
75359: , h5.TRX_INVOICE_CURRENCY_CODE source_47
75360: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
75361: , h5.TRX_DOC_SEQUENCE_ID source_112
75362: FROM xla_events_gt xet
75363: , AR_BILL_TO_CUSTOMERS_S_V h1
75364: , AR_BILL_TO_SITE_USES_S_V h2
75365: , AR_TRANSACTIONS_S_V h5
75366: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
75411: , l3.TRX_LINE_CUR_CONVERSION_DATE source_48
75412: , l3.TRX_LINE_CUR_CONVERSION_RATE source_49
75413: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_50
75414: , l3.TRX_LINE_ACCTD_AMT source_51
75415: FROM xla_events_gt xet
75416: , AR_CUST_TRX_LINES_BASE_V l3
75417: , AR_CUST_TRX_LINES_L_V l4
75418: WHERE xet.event_id between x_first_event_id and x_last_event_id
75419: and xet.event_date between p_pad_start_date and p_pad_end_date
76248:
76249: ELSE null
76250: END source_value
76251: , null source_meaning
76252: FROM xla_events_gt xet
76253: , AR_BILL_TO_CUSTOMERS_S_V h1
76254: , AR_BILL_TO_SITE_USES_S_V h2
76255: , AR_TRANSACTIONS_S_V h5
76256: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
76405:
76406: ELSE null
76407: END source_value
76408: , null source_meaning
76409: FROM xla_events_gt xet
76410: , AR_CUST_TRX_LINES_BASE_V l3
76411: , AR_CUST_TRX_LINES_L_V l4
76412: , (select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
76413: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76625: , h5.XLA_PARTY_TYPE source_39
76626: , h5.TRX_INVOICE_CURRENCY_CODE source_47
76627: , h5.TRX_DOC_SEQUENCE_CATEGORY source_111
76628: , h5.TRX_DOC_SEQUENCE_ID source_112
76629: FROM xla_events_gt xet
76630: , AR_BILL_TO_CUSTOMERS_S_V h1
76631: , AR_BILL_TO_SITE_USES_S_V h2
76632: , AR_TRANSACTIONS_S_V h5
76633: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76681: , l3.TRX_LINE_ACCTD_AMT source_51
76682: , l4.TRX_LINE_INTERFACE_LINE_ATTR1 source_65
76683: , l4.TRX_TAX_LINE_ID source_86
76684: , l3.ROUNDING_CORRECTION_FLAG source_87
76685: FROM xla_events_gt xet
76686: , AR_CUST_TRX_LINES_BASE_V l3
76687: , AR_CUST_TRX_LINES_L_V l4
76688: WHERE xet.event_id between x_first_event_id and x_last_event_id
76689: and xet.event_date between p_pad_start_date and p_pad_end_date
77838:
77839: ELSE null
77840: END source_value
77841: , null source_meaning
77842: FROM xla_events_gt xet
77843: , AR_CASH_RECEIPTS_H_V h1
77844: , AR_RCT_METHOD_H_V h4
77845: , AR_RECEIVABLES_TRX_MISC_H_V h5
77846: , AR_REMIT_BANK_ACCT_H_V h6
77992:
77993: ELSE null
77994: END source_value
77995: , null source_meaning
77996: FROM xla_events_gt xet
77997: , AR_DISTRIBUTIONS_BASE_V l2
77998: , AR_DISTRIBUTIONS_L_V l3
77999: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
78000: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78222: , h5.MC_ACT_NAME source_91
78223: , h1.RCT_DOC_SEQUENCE_CATEGORY source_117
78224: , h1.RCT_DOC_SEQUENCE_ID source_118
78225: , h1.RCT_TRX_ACCT_REVERSAL source_119
78226: FROM xla_events_gt xet
78227: , AR_CASH_RECEIPTS_H_V h1
78228: , AR_RCT_METHOD_H_V h4
78229: , AR_RECEIVABLES_TRX_MISC_H_V h5
78230: , AR_REMIT_BANK_ACCT_H_V h6
78279: , l2.DIST_CUR_CONVERSION_TYPE source_35
78280: , l2.DIST_TO_ACCTD_AMT source_36
78281: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_88
78282: , l2.DIST_TO_CUR_CONVERSION_DATE source_89
78283: FROM xla_events_gt xet
78284: , AR_DISTRIBUTIONS_BASE_V l2
78285: , AR_DISTRIBUTIONS_L_V l3
78286: WHERE xet.event_id between x_first_event_id and x_last_event_id
78287: and xet.event_date between p_pad_start_date and p_pad_end_date
79371:
79372: ELSE null
79373: END source_value
79374: , null source_meaning
79375: FROM xla_events_gt xet
79376: , AR_CASH_RECEIPTS_H_V h1
79377: , AR_RCT_METHOD_H_V h5
79378: , AR_RCT_SITE_USES_H_V h6
79379: , AR_REMIT_BANK_ACCT_H_V h8
79622:
79623: ELSE null
79624: END source_value
79625: , null source_meaning
79626: FROM xla_events_gt xet
79627: , AR_CUST_TRX_LINES_L_V l2
79628: , AR_DISTRIBUTIONS_BASE_V l3
79629: , AR_DISTRIBUTIONS_L_V l4
79630: , AR_RECEIVABLES_TRX_ACT_S_V l7
79917: , h1.RCT_APP_STATUS source_106
79918: , h1.RCT_DOC_SEQUENCE_CATEGORY source_117
79919: , h1.RCT_DOC_SEQUENCE_ID source_118
79920: , h1.RCT_TRX_ACCT_REVERSAL source_119
79921: FROM xla_events_gt xet
79922: , AR_CASH_RECEIPTS_H_V h1
79923: , AR_RCT_METHOD_H_V h5
79924: , AR_RCT_SITE_USES_H_V h6
79925: , AR_REMIT_BANK_ACCT_H_V h8
79995: , l3.DIST_TO_CUR_CONVERSION_TYPE source_100
79996: , l3.DIST_TO_CUR_CONVERSION_RATE source_101
79997: , l4.DIST_SOURCE_TABLE source_102
79998: , l7.REC_ACT_NAME source_103
79999: FROM xla_events_gt xet
80000: , AR_CUST_TRX_LINES_L_V l2
80001: , AR_DISTRIBUTIONS_BASE_V l3
80002: , AR_DISTRIBUTIONS_L_V l4
80003: , AR_RECEIVABLES_TRX_ACT_S_V l7
82236: ,p_level => C_LEVEL_STATEMENT
82237: ,p_module => l_log_module);
82238:
82239: trace
82240: (p_msg => '# of events in xla_events_gt: '
82241: ||xla_context_pkg.get_event_count_context
82242: ,p_level => C_LEVEL_STATEMENT
82243: ,p_module => l_log_module);
82244: