[Home] [Help]
36505: WHEN 2 THEN fvl13.meaning
36506:
36507: ELSE null
36508: END source_meaning
36509: FROM xla_events_gt xet
36510: , AP_INVOICE_EXTRACT_HEADER_V h2
36511: , fnd_lookup_values fvl13
36512: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
36513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
36829: WHEN 33 THEN fvl42.meaning
36830:
36831: ELSE null
36832: END source_meaning
36833: FROM xla_events_gt xet
36834: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
36835: , FV_XLA_AP_REF_V l3
36836: , ZX_AP_DEF_TAX_EXTRACT_V l4
36837: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
37152: , h2.THIRD_PARTY_TYPE source_45
37153: , h2.INV_DOC_SEQUENCE_CATEGORY source_71
37154: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
37155: , h2.INV_DOC_SEQUENCE_VALUE source_73
37156: FROM xla_events_gt xet
37157: , AP_INVOICE_EXTRACT_HEADER_V h2
37158: , fnd_lookup_values fvl13
37159: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
37160: and xet.event_class_code = C_EVENT_CLASS_CODE
37244: , l1.ENCUMBRANCE_BASE_AMOUNT source_53
37245: , l3.FEDERAL_UNANTICIPATED_AMT source_54
37246: , l1.AID_AMOUNT source_55
37247: , l1.INV_DIST_BASE_AMOUNT source_56
37248: FROM xla_events_gt xet
37249: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
37250: , FV_XLA_AP_REF_V l3
37251: , ZX_AP_DEF_TAX_EXTRACT_V l4
37252: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
38850: WHEN 2 THEN fvl13.meaning
38851:
38852: ELSE null
38853: END source_meaning
38854: FROM xla_events_gt xet
38855: , AP_INVOICE_EXTRACT_HEADER_V h2
38856: , fnd_lookup_values fvl13
38857: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
38858: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
39174: WHEN 33 THEN fvl42.meaning
39175:
39176: ELSE null
39177: END source_meaning
39178: FROM xla_events_gt xet
39179: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
39180: , FV_XLA_AP_REF_V l3
39181: , ZX_AP_DEF_TAX_EXTRACT_V l4
39182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
39497: , h2.THIRD_PARTY_TYPE source_45
39498: , h2.INV_DOC_SEQUENCE_CATEGORY source_71
39499: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
39500: , h2.INV_DOC_SEQUENCE_VALUE source_73
39501: FROM xla_events_gt xet
39502: , AP_INVOICE_EXTRACT_HEADER_V h2
39503: , fnd_lookup_values fvl13
39504: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
39505: and xet.event_class_code = C_EVENT_CLASS_CODE
39589: , l3.FEDERAL_UNANTICIPATED_AMT source_54
39590: , l1.AID_AMOUNT source_55
39591: , l1.INV_DIST_BASE_AMOUNT source_56
39592: , l1.AID_BASE_AMT_NO_ROUND source_58
39593: FROM xla_events_gt xet
39594: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
39595: , FV_XLA_AP_REF_V l3
39596: , ZX_AP_DEF_TAX_EXTRACT_V l4
39597: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
41189: WHEN 11 THEN fvl60.meaning
41190:
41191: ELSE null
41192: END source_meaning
41193: FROM xla_events_gt xet
41194: , AP_INVOICE_EXTRACT_HEADER_V h2
41195: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41196: , fnd_lookup_values fvl13
41197: , fnd_lookup_values fvl60
41574: WHEN 33 THEN fvl42.meaning
41575:
41576: ELSE null
41577: END source_meaning
41578: FROM xla_events_gt xet
41579: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
41580: , FV_XLA_AP_REF_V l4
41581: , ZX_AP_DEF_TAX_EXTRACT_V l5
41582: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
41924: , fvl60.meaning source_60_meaning
41925: , h2.INV_DOC_SEQUENCE_CATEGORY source_71
41926: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
41927: , h2.INV_DOC_SEQUENCE_VALUE source_73
41928: FROM xla_events_gt xet
41929: , AP_INVOICE_EXTRACT_HEADER_V h2
41930: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41931: , fnd_lookup_values fvl13
41932: , fnd_lookup_values fvl60
42033: , l1.BUS_FLOW_PO_ENTITY_CODE source_66
42034: , l1.BUS_FLOW_PO_DIST_ID source_67
42035: , l1.BUS_FLOW_PO_DOC_ID source_68
42036: , l4.FEDERAL_PAID_UNEXP_OBG_AMT source_69
42037: FROM xla_events_gt xet
42038: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
42039: , FV_XLA_AP_REF_V l4
42040: , ZX_AP_DEF_TAX_EXTRACT_V l5
42041: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
44213: WHEN 1 THEN fvl13.meaning
44214:
44215: ELSE null
44216: END source_meaning
44217: FROM xla_events_gt xet
44218: , AP_INVOICE_EXTRACT_HEADER_V h2
44219: , fnd_lookup_values fvl13
44220: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
44221: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
44490: WHEN 25 THEN fvl42.meaning
44491:
44492: ELSE null
44493: END source_meaning
44494: FROM xla_events_gt xet
44495: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
44496: , FV_XLA_AP_REF_V l3
44497: , ZX_AP_DEF_TAX_EXTRACT_V l4
44498: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
44779: , h2.THIRD_PARTY_TYPE source_45
44780: , h2.INV_DOC_SEQUENCE_CATEGORY source_71
44781: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
44782: , h2.INV_DOC_SEQUENCE_VALUE source_73
44783: FROM xla_events_gt xet
44784: , AP_INVOICE_EXTRACT_HEADER_V h2
44785: , fnd_lookup_values fvl13
44786: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
44787: and xet.event_class_code = C_EVENT_CLASS_CODE
44860: , l1.UPG_DR_ENC_TYPE_ID source_52
44861: , l1.AID_AMOUNT source_55
44862: , l1.INV_DIST_BASE_AMOUNT source_56
44863: , l1.POD_PO_DISTRIBUTION_ID source_70
44864: FROM xla_events_gt xet
44865: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
44866: , FV_XLA_AP_REF_V l3
44867: , ZX_AP_DEF_TAX_EXTRACT_V l4
44868: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
45898: ,p_level => C_LEVEL_STATEMENT
45899: ,p_module => l_log_module);
45900:
45901: trace
45902: (p_msg => '# of events in xla_events_gt: '
45903: ||xla_context_pkg.get_event_count_context
45904: ,p_level => C_LEVEL_STATEMENT
45905: ,p_module => l_log_module);
45906: