[Home] [Help]
65341: WHEN 5 THEN fvl17.meaning
65342:
65343: ELSE null
65344: END source_meaning
65345: FROM xla_events_gt xet
65346: , AP_INVOICE_EXTRACT_HEADER_V h2
65347: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
65348: , fnd_lookup_values fvl7
65349: , fnd_lookup_values fvl12
65693: WHEN 38 THEN fvl59.meaning
65694:
65695: ELSE null
65696: END source_meaning
65697: FROM xla_events_gt xet
65698: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
65699: , ZX_AP_DEF_TAX_EXTRACT_V l4
65700: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
65701: , fnd_lookup_values fvl9
66045: , h2.THIRD_PARTY_TYPE source_49
66046: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
66047: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
66048: , h2.INV_DOC_SEQUENCE_VALUE source_124
66049: FROM xla_events_gt xet
66050: , AP_INVOICE_EXTRACT_HEADER_V h2
66051: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
66052: , fnd_lookup_values fvl7
66053: , fnd_lookup_values fvl12
66153: , l1.ENCUMBRANCE_AMOUNT source_65
66154: , l1.ENCUMBRANCE_BASE_AMOUNT source_66
66155: , l1.AID_QUANTITY_VARIANCE source_81
66156: , l1.AID_BASE_QUANTITY_VARIANCE source_82
66157: FROM xla_events_gt xet
66158: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
66159: , ZX_AP_DEF_TAX_EXTRACT_V l4
66160: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
66161: , fnd_lookup_values fvl9
68199: WHEN 5 THEN fvl17.meaning
68200:
68201: ELSE null
68202: END source_meaning
68203: FROM xla_events_gt xet
68204: , AP_INVOICE_EXTRACT_HEADER_V h2
68205: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68206: , fnd_lookup_values fvl7
68207: , fnd_lookup_values fvl12
68546: WHEN 37 THEN fvl59.meaning
68547:
68548: ELSE null
68549: END source_meaning
68550: FROM xla_events_gt xet
68551: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
68552: , ZX_AP_DEF_TAX_EXTRACT_V l4
68553: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
68554: , fnd_lookup_values fvl9
68896: , h2.THIRD_PARTY_TYPE source_49
68897: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
68898: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
68899: , h2.INV_DOC_SEQUENCE_VALUE source_124
68900: FROM xla_events_gt xet
68901: , AP_INVOICE_EXTRACT_HEADER_V h2
68902: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
68903: , fnd_lookup_values fvl7
68904: , fnd_lookup_values fvl12
69003: , l1.ENCUMBRANCE_AMOUNT source_65
69004: , l1.ENCUMBRANCE_BASE_AMOUNT source_66
69005: , l1.AID_QUANTITY_VARIANCE source_81
69006: , l1.AID_BASE_QUANTITY_VARIANCE source_82
69007: FROM xla_events_gt xet
69008: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
69009: , ZX_AP_DEF_TAX_EXTRACT_V l4
69010: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
69011: , fnd_lookup_values fvl9
71037: WHEN 14 THEN fvl68.meaning
71038:
71039: ELSE null
71040: END source_meaning
71041: FROM xla_events_gt xet
71042: , AP_INVOICE_EXTRACT_HEADER_V h2
71043: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71044: , fnd_lookup_values fvl7
71045: , fnd_lookup_values fvl12
71399: WHEN 39 THEN fvl59.meaning
71400:
71401: ELSE null
71402: END source_meaning
71403: FROM xla_events_gt xet
71404: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
71405: , ZX_AP_DEF_TAX_EXTRACT_V l4
71406: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71407: , fnd_lookup_values fvl9
71758: , fvl68.meaning source_68_meaning
71759: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
71760: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
71761: , h2.INV_DOC_SEQUENCE_VALUE source_124
71762: FROM xla_events_gt xet
71763: , AP_INVOICE_EXTRACT_HEADER_V h2
71764: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
71765: , fnd_lookup_values fvl7
71766: , fnd_lookup_values fvl12
71872: , l1.ENCUMBRANCE_AMOUNT source_65
71873: , l1.ENCUMBRANCE_BASE_AMOUNT source_66
71874: , l1.AID_QUANTITY_VARIANCE source_81
71875: , l1.AID_BASE_QUANTITY_VARIANCE source_82
71876: FROM xla_events_gt xet
71877: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
71878: , ZX_AP_DEF_TAX_EXTRACT_V l4
71879: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
71880: , fnd_lookup_values fvl9
74179: WHEN 38 THEN fvl108.meaning
74180:
74181: ELSE null
74182: END source_meaning
74183: FROM xla_events_gt xet
74184: , PA_XLA_BC_PKT_AP_DETAIL_V l1
74185: , PA_XLA_EXP_ORG_REF_V l2
74186: , PA_XLA_PROJECT_REF_V l3
74187: , PA_XLA_TASK_REF_V l4
74462: ,xet.reference_date_3
74463: ,xet.reference_date_4
74464: ,xet.event_created_by
74465: ,xet.budgetary_control_flag
74466: FROM xla_events_gt xet
74467: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
74468: and xet.event_class_code = C_EVENT_CLASS_CODE
74469: and xet.event_status_code <> 'N'
74470: ORDER BY event_id
74552: , l1.PO_ENTITY_CODE source_118
74553: , l1.PO_FIRST_DIST_ID source_119
74554: , l1.PO_FIRST_SYS_TRANS_ID source_120
74555: , l1.PO_SECOND_DIST_ID source_121
74556: FROM xla_events_gt xet
74557: , PA_XLA_BC_PKT_AP_DETAIL_V l1
74558: , PA_XLA_EXP_ORG_REF_V l2
74559: , PA_XLA_PROJECT_REF_V l3
74560: , PA_XLA_TASK_REF_V l4
75829: WHEN 1 THEN fvl17.meaning
75830:
75831: ELSE null
75832: END source_meaning
75833: FROM xla_events_gt xet
75834: , AP_INVOICE_EXTRACT_HEADER_V h1
75835: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
75836: , fnd_lookup_values fvl17
75837: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
76107: WHEN 14 THEN fvl46.meaning
76108:
76109: ELSE null
76110: END source_meaning
76111: FROM xla_events_gt xet
76112: , AP_PREPAYAPP_EXTRACT_DTLS_BC_V l2
76113: , ZX_AP_DEF_TAX_EXTRACT_V l4
76114: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
76115: , fnd_lookup_values fvl46
76380: , h1.THIRD_PARTY_TYPE source_49
76381: , h1.INV_DOC_SEQUENCE_CATEGORY source_122
76382: , h1.INV_DOC_SEQUENCE_IDENTIFIER source_123
76383: , h1.INV_DOC_SEQUENCE_VALUE source_124
76384: FROM xla_events_gt xet
76385: , AP_INVOICE_EXTRACT_HEADER_V h1
76386: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
76387: , fnd_lookup_values fvl17
76388: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
76462: , l2.UPG_ENC_DR_ACCT_CLASS source_77
76463: , l2.APAD_AMOUNT source_78
76464: , l2.APAD_BASE_AMOUNT source_79
76465: , l2.REVERSED_PREPAY_APP_DIST_ID source_80
76466: FROM xla_events_gt xet
76467: , AP_PREPAYAPP_EXTRACT_DTLS_BC_V l2
76468: , ZX_AP_DEF_TAX_EXTRACT_V l4
76469: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
76470: , fnd_lookup_values fvl46
77471: WHEN 5 THEN fvl17.meaning
77472:
77473: ELSE null
77474: END source_meaning
77475: FROM xla_events_gt xet
77476: , AP_INVOICE_EXTRACT_HEADER_V h2
77477: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
77478: , fnd_lookup_values fvl7
77479: , fnd_lookup_values fvl12
77823: WHEN 38 THEN fvl59.meaning
77824:
77825: ELSE null
77826: END source_meaning
77827: FROM xla_events_gt xet
77828: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
77829: , ZX_AP_DEF_TAX_EXTRACT_V l4
77830: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
77831: , fnd_lookup_values fvl9
78175: , h2.THIRD_PARTY_TYPE source_49
78176: , h2.INV_DOC_SEQUENCE_CATEGORY source_122
78177: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_123
78178: , h2.INV_DOC_SEQUENCE_VALUE source_124
78179: FROM xla_events_gt xet
78180: , AP_INVOICE_EXTRACT_HEADER_V h2
78181: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
78182: , fnd_lookup_values fvl7
78183: , fnd_lookup_values fvl12
78283: , l1.ENCUMBRANCE_AMOUNT source_65
78284: , l1.ENCUMBRANCE_BASE_AMOUNT source_66
78285: , l1.AID_QUANTITY_VARIANCE source_81
78286: , l1.AID_BASE_QUANTITY_VARIANCE source_82
78287: FROM xla_events_gt xet
78288: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
78289: , ZX_AP_DEF_TAX_EXTRACT_V l4
78290: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
78291: , fnd_lookup_values fvl9
80479: WHEN 39 THEN fvl108.meaning
80480:
80481: ELSE null
80482: END source_meaning
80483: FROM xla_events_gt xet
80484: , PA_XLA_BC_PKT_AP_DETAIL_V l1
80485: , PA_XLA_EXP_ORG_REF_V l2
80486: , PA_XLA_PROJECT_REF_V l3
80487: , PA_XLA_TASK_REF_V l4
80750: ,xet.reference_date_3
80751: ,xet.reference_date_4
80752: ,xet.event_created_by
80753: ,xet.budgetary_control_flag
80754: FROM xla_events_gt xet
80755: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
80756: and xet.event_class_code = C_EVENT_CLASS_CODE
80757: and xet.event_status_code <> 'N'
80758: ORDER BY event_id
80834: , l1.PA_ENTITY_CODE source_111
80835: , l1.PA_FIRST_DIST_ID source_112
80836: , l1.PA_FIRST_SYS_TRANS_ID source_113
80837: , l1.PA_SECOND_DIST_ID source_114
80838: FROM xla_events_gt xet
80839: , PA_XLA_BC_PKT_AP_DETAIL_V l1
80840: , PA_XLA_EXP_ORG_REF_V l2
80841: , PA_XLA_PROJECT_REF_V l3
80842: , PA_XLA_TASK_REF_V l4
82129: WHEN 36 THEN fvl108.meaning
82130:
82131: ELSE null
82132: END source_meaning
82133: FROM xla_events_gt xet
82134: , PA_XLA_BC_PKT_AP_DETAIL_V l1
82135: , PA_XLA_EXP_ORG_REF_V l2
82136: , PA_XLA_PROJECT_REF_V l3
82137: , PA_XLA_TASK_REF_V l4
82394: ,xet.reference_date_3
82395: ,xet.reference_date_4
82396: ,xet.event_created_by
82397: ,xet.budgetary_control_flag
82398: FROM xla_events_gt xet
82399: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
82400: and xet.event_class_code = C_EVENT_CLASS_CODE
82401: and xet.event_status_code <> 'N'
82402: ORDER BY event_id
82475: , l1.PA_ENTITY_CODE source_111
82476: , l1.PA_FIRST_DIST_ID source_112
82477: , l1.PA_FIRST_SYS_TRANS_ID source_113
82478: , l1.PA_SECOND_DIST_ID source_114
82479: FROM xla_events_gt xet
82480: , PA_XLA_BC_PKT_AP_DETAIL_V l1
82481: , PA_XLA_EXP_ORG_REF_V l2
82482: , PA_XLA_PROJECT_REF_V l3
82483: , PA_XLA_TASK_REF_V l4
83760: ,p_level => C_LEVEL_STATEMENT
83761: ,p_module => l_log_module);
83762:
83763: trace
83764: (p_msg => '# of events in xla_events_gt: '
83765: ||xla_context_pkg.get_event_count_context
83766: ,p_level => C_LEVEL_STATEMENT
83767: ,p_module => l_log_module);
83768: