[Home] [Help]
47275:
47276: ELSE null
47277: END source_value
47278: , null source_meaning
47279: FROM xla_events_gt xet
47280: , PO_EXTRACT_HEADER_V h4
47281: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
47282: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
47283: AND xet.event_class_code = C_EVENT_CLASS_CODE
47523:
47524: ELSE null
47525: END source_value
47526: , null source_meaning
47527: FROM xla_events_gt xet
47528: , FV_XLA_PO_REF_V l1
47529: , PO_DISTS_REF_V l2
47530: , PO_EXTRACT_DETAIL_V l3
47531: , (select rownum r from all_objects where rownum <= 31 and owner = p_apps_owner)
47772: , h4.PO_NUMBER source_2
47773: , h4.PO_HEADER_ID source_20
47774: , h4.ENCUMBRANCE_TYPE_ID source_48
47775: , h4.GL_DATE source_49
47776: FROM xla_events_gt xet
47777: , PO_EXTRACT_HEADER_V h4
47778: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
47779: and xet.event_class_code = C_EVENT_CLASS_CODE
47780: and xet.event_status_code <> 'N' AND h4.event_id = xet.event_id
47843: , l2.CURRENCY_CONVERSION_TYPE source_37
47844: , l1.FEDERAL_PYA_DIFF_AMT source_38
47845: , l1.FEDERAL_ANTICIPATED_AMT source_39
47846: , l1.FEDERAL_PYA_AMT source_40
47847: FROM xla_events_gt xet
47848: , FV_XLA_PO_REF_V l1
47849: , PO_DISTS_REF_V l2
47850: , PO_EXTRACT_DETAIL_V l3
47851: WHERE xet.event_id between x_first_event_id and x_last_event_id
50079:
50080: ELSE null
50081: END source_value
50082: , null source_meaning
50083: FROM xla_events_gt xet
50084: , PO_EXTRACT_HEADER_V h4
50085: , PO_RELEASES_REF_V h5
50086: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
50087: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
50323:
50324: ELSE null
50325: END source_value
50326: , null source_meaning
50327: FROM xla_events_gt xet
50328: , FV_XLA_PO_REF_V l1
50329: , PO_DISTS_REF_V l2
50330: , PO_EXTRACT_DETAIL_V l3
50331: , (select rownum r from all_objects where rownum <= 30 and owner = p_apps_owner)
50573: , h5.PO_RELEASE_NUMBER source_4
50574: , h4.PO_RELEASE_ID source_41
50575: , h4.ENCUMBRANCE_TYPE_ID source_48
50576: , h4.GL_DATE source_49
50577: FROM xla_events_gt xet
50578: , PO_EXTRACT_HEADER_V h4
50579: , PO_RELEASES_REF_V h5
50580: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
50581: and xet.event_class_code = C_EVENT_CLASS_CODE
50644: , l2.CURRENCY_CONVERSION_TYPE source_37
50645: , l1.FEDERAL_PYA_DIFF_AMT source_38
50646: , l1.FEDERAL_ANTICIPATED_AMT source_39
50647: , l1.FEDERAL_PYA_AMT source_40
50648: FROM xla_events_gt xet
50649: , FV_XLA_PO_REF_V l1
50650: , PO_DISTS_REF_V l2
50651: , PO_EXTRACT_DETAIL_V l3
50652: WHERE xet.event_id between x_first_event_id and x_last_event_id
52583:
52584: ELSE null
52585: END source_value
52586: , null source_meaning
52587: FROM xla_events_gt xet
52588: , PO_REQ_EXTRACT_HEADER_V h3
52589: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
52590: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52591: AND xet.event_class_code = C_EVENT_CLASS_CODE
52791:
52792: ELSE null
52793: END source_value
52794: , null source_meaning
52795: FROM xla_events_gt xet
52796: , FV_XLA_PO_REF_V l1
52797: , PO_REQ_EXTRACT_DETAIL_V l2
52798: , PO_REQ_LINES_REF_V l4
52799: , (select rownum r from all_objects where rownum <= 23 and owner = p_apps_owner)
53024: , h3.REQ_NUMBER source_6
53025: , h3.REQ_ID source_44
53026: , h3.ENCUMBRANCE_TYPE_ID source_48
53027: , h3.GL_DATE source_49
53028: FROM xla_events_gt xet
53029: , PO_REQ_EXTRACT_HEADER_V h3
53030: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
53031: and xet.event_class_code = C_EVENT_CLASS_CODE
53032: and xet.event_status_code <> 'N' AND h3.event_id = xet.event_id
53087: , l2.REQ_DISTRIBUTION_ID source_43
53088: , l2.REQ_ENCUM_UPG_OPTION source_45
53089: , l2.REQ_UPG_ENC_TYPE_ID source_46
53090: , l2.ADJUSTMENT_STATUS source_47
53091: FROM xla_events_gt xet
53092: , FV_XLA_PO_REF_V l1
53093: , PO_REQ_EXTRACT_DETAIL_V l2
53094: , PO_REQ_LINES_REF_V l4
53095: WHERE xet.event_id between x_first_event_id and x_last_event_id
54112: ,p_level => C_LEVEL_STATEMENT
54113: ,p_module => l_log_module);
54114:
54115: trace
54116: (p_msg => '# of events in xla_events_gt: '
54117: ||xla_context_pkg.get_event_count_context
54118: ,p_level => C_LEVEL_STATEMENT
54119: ,p_module => l_log_module);
54120: