4 Replies Latest reply on Jun 8, 2017 3:11 PM by Flammifer

    APEX page load performance

    Flammifer

      I've attemped to speed up page load in all problematic cases by leaving Maximum Row Count blank. Usually it helps, but on specific page I noticed under debug, that if I remove Maximum Row Count 1000000, then another part becomes a problem taking either as much time or more, and that's last IR binding value, so:

      0.24161107.79628
      IR binding: "F_USER_NAME" value=""

       

      So 107.79628 is elapsed time, which is way over the top.

       

      And I simply don't understand where to look up anything related to this. What am I even looking at here exactly? IR bind variable assigned empty value?

        • 1. Re: APEX page load performance
          fac586

          Flammifer wrote:

           

          I've attemped to speed up page load in all problematic cases by leaving Maximum Row Count blank. Usually it helps, but on specific page I noticed under debug, that if I remove Maximum Row Count 1000000, then another part becomes a problem taking either as much time or more, and that's last IR binding value, so:

          0.24161107.79628
          IR binding: "F_USER_NAME" value=""

           

          And I simply don't understand where to look up anything related to this. What am I even looking at here exactly? IR bind variable assigned empty value?

          An unclear and generally confusing debug entry. Essentially this is the elapsed time required to execute the IR query and return the displayed set of results.

          So 107.79628 is elapsed time, which is way over the top.

          Indeed it is, but we do not have sufficient information to even begin to speculate on possible reasons for this. The following data is required in order to investigate performance problems:

           

          • Full details of the environment
          • A description of the objects (DDL for tables, indexes, partitions etc) involved
          • An indication of the nature, volume, and distribution of the data
          • A quantitative description of the performance problem, including

           

          Post this as text, not screen shots.

          • 2. Re: APEX page load performance
            Flammifer

            OK, thanks, I will then return to the topic with collected details when I manage to do so.

            • 3. Re: APEX page load performance
              Flammifer
              • APEX version - 5.0.1
              • DB version, edition and host OS
                     Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production0
                     PL/SQL Release 12.1.0.2.0 - Production0
                    CORE12.1.0.2.0Production0
                    TNS for Linux: Version 12.1.0.2.0 - Production0

                     NLSRTL Version 12.1.0.2.0 - Production

              • Web server architecture (EPG, OHS or APEX listener), server platform, and host OS - Apex Listener, Linux
              • Browser(s)/version(s) used  - Chrome 59.0.3071.86
              • UI/Theme - Universal theme
              • Templates - Standard
              • Region type (making particular distinction as to whether a "report" is a standard report, an interactive report, or in fact an "updateable report" (i.e. a tabular form) - Interactive Report

               

              • A description of the objects (DDL for tables, indexes, partitions etc) involved

               

              Most of the objects are APPS tables, couple of views, and some tables. I can share DDL for these tables, I might exclude few views, because this is a lot of data for one post, but if it will be needed - I'll post additionally.

               

              CREATE TABLE "XXEXT"."XXEXT_AP_HOLDS_COMMENTS"

                 ( "HOLD_COMMENT_ID" NUMBER NOT NULL ENABLE,

                "HOLD_ID" NUMBER NOT NULL ENABLE,

                "COMMENTS" VARCHAR2(4000 BYTE),

                "ATTACHMENT" BLOB,

                "FILENAME" VARCHAR2(400 BYTE),

                "FILE_MIME_TYPE" VARCHAR2(255 BYTE),

                "COMMENT_TYPE" VARCHAR2(100 BYTE),

                "FLG_PRIVATE_AP_NOTE" NUMBER,

                "LAST_UPDATED_BY" NUMBER,

                "LAST_UPDATE_DATE" DATE,

                "CREATED_BY" NUMBER,

                "CREATION_DATE" DATE,

                CONSTRAINT "XXEXT_AP_HOLDS_COMMENTS_PK" PRIMARY KEY ("HOLD_COMMENT_ID")

                 )

               

              INDEXES:

              XXEXTXXEXT_AP_HOLDS_COMMENTS_PKUNIQUEVALIDNORMALNNONOHOLD_COMMENT_ID
              XXEXTXXEXT_AP_HOLDS_COMMENTS_IDX1NONUNIQUEVALIDNORMALNNONOHOLD_ID

               

              CREATE TABLE "XXDW"."XXDW_PROJECTS_DTL_T"

                 ( "PROJECT_ID" NUMBER(15,0) NOT NULL ENABLE,

                "TARGET_START_DATE" DATE,

                "TARGET_END_DATE" DATE,

                "BUILDING_TYPE" VARCHAR2(50 BYTE),

                "CONSTRUCTION_TYPE" VARCHAR2(50 BYTE),

                "CONSTRUCTION_METHOD" VARCHAR2(50 BYTE),

                "CONTRACT_TYPE" VARCHAR2(74 BYTE),

                "PROJECT_CATEGORY" VARCHAR2(100 BYTE),

                "PROJECT_STAGE" VARCHAR2(74 BYTE),

                "CUSTOMER_NAME" VARCHAR2(360 BYTE),

                "BD_ESTIMATOR" VARCHAR2(240 BYTE),

                "PROJECT_MANAGER" VARCHAR2(240 BYTE),

                "PROJECT_EXECUTIVE" VARCHAR2(240 BYTE),

                "CONTRACT_ADMINISTRATOR" VARCHAR2(240 BYTE),

                "PROJECT_ACCOUNTANT" VARCHAR2(240 BYTE),

                "LIGHTING_PM" VARCHAR2(240 BYTE),

                "SENIOR_LIGHTING_PM" VARCHAR2(240 BYTE),

                "LV_PM" VARCHAR2(240 BYTE),

                "LV_PROJECT_EXECUTIVE" VARCHAR2(240 BYTE),

                "FA_PM" VARCHAR2(240 BYTE),

                "FA_PROJECT_EXECUTIVE" VARCHAR2(240 BYTE),

                "PDI_ENGINEER" VARCHAR2(240 BYTE),

                "PDI_COORDINATOR" VARCHAR2(240 BYTE),

                "PDI_SR_COORDINATOR" VARCHAR2(240 BYTE),

                "PDI_DESIGNER" VARCHAR2(240 BYTE),

                "SUPERINTENDENT" VARCHAR2(4000 BYTE),

                "PROJECT_CITY" VARCHAR2(30 BYTE),

                "PROJECT_STATE" VARCHAR2(120 BYTE),

                "CARRYING_OUT_ORGANIZATION" VARCHAR2(240 BYTE),

                "PARENT_ORGANIZATION" VARCHAR2(240 BYTE),

                "CREATION_DATE" DATE NOT NULL ENABLE,

                "PROJECT_CLOSED_DATE" DATE,

                "PROJECT_WARRANTY_DATE" DATE,

                "PROJECT_APPROVED_DATE" DATE,

                "PROJECT_LEGAL_DATE" DATE,

                "PROJECT_DESCRIPTION" VARCHAR2(250 BYTE),

                "PROJECT_LONG_NAME" VARCHAR2(240 BYTE),

                "PROJECT_NAME" VARCHAR2(30 BYTE) NOT NULL ENABLE,

                "PROJECT_STATUS" VARCHAR2(80 BYTE),

                "PROJECT_NUMBER" VARCHAR2(25 BYTE) NOT NULL ENABLE,

                "PROJECT_START_DATE" DATE,

                "PROJECT_TYPE" VARCHAR2(20 BYTE) NOT NULL ENABLE,

                "PROJECT_TYPE_CLASS" VARCHAR2(30 BYTE),

                "RETENTION_PERCENTAGE" NUMBER,

                "UNBILLED_RECEIVABLES" NUMBER,

                "UNEARNED_REVENUE" NUMBER,

                "NUMBER_OF_UNITS" NUMBER,

                "DOM_PROJECTED_GP" NUMBER,

                "SQUARE_FOOTAGE" NUMBER,

                "PW_ELIGIBILITY" VARCHAR2(150 BYTE),

                "ADDRESS" VARCHAR2(1200 BYTE),

                "ADDRESS_LINE_1" VARCHAR2(240 BYTE),

                "ADDRESS_LINE_2" VARCHAR2(240 BYTE),

                "ADDRESS_LINE_3" VARCHAR2(240 BYTE),

                "REGION_1" VARCHAR2(120 BYTE),

                "REGION_2" VARCHAR2(120 BYTE),

                "ZIPCODE" VARCHAR2(30 BYTE),

                "BUILDING_GSF" NUMBER,

                "RETAIL_GSF" NUMBER,

                "OFFICE_GSF" NUMBER,

                "UNIT_NSF" NUMBER,

                "GARAGE_GSF" NUMBER,

                "AMENITY_GSF" NUMBER,

                "PDI_MARKET" VARCHAR2(50 BYTE),

                "BPM_REGION" VARCHAR2(50 BYTE),

                "DURATION" NUMBER,

                "DEVELOPER" VARCHAR2(200 BYTE),

                "PARENT_COMPANY" VARCHAR2(200 BYTE),

                "GENERAL_CONTRACTOR" VARCHAR2(200 BYTE),

                "ARCHITECT" VARCHAR2(200 BYTE),

                "ENGINEER" VARCHAR2(200 BYTE),

                "CON_START_DATE" DATE,

                "TAX_RATE" NUMBER,

                "NUMBER_OF_WDS" NUMBER,

                "NUMBER_OF_PCOS" NUMBER,

                "PROJECT_BASELINED_FLAG" VARCHAR2(4000 BYTE),

                "RTN_REDUCTION_TERMS" VARCHAR2(240 BYTE),

                "RTN_REDUCTION_TERMS_OTHERS" VARCHAR2(240 BYTE),

                "PDI_CONTRACT_STATUS" VARCHAR2(240 BYTE),

                "NUMBER_OF_APPROVED_COS" NUMBER,

                "LAST_COST_DATE" DATE,

                "BASELINE_DFF" VARCHAR2(4000 BYTE),

                "LAST_ITR_PROCESS_DATE" DATE,

                "LAST_PAYROLL_PROCESS_DATE" DATE,

                "DATAMART_CREATION_DATE" DATE,

                "CREATED_BY" NUMBER,

                "BPM_PROJECT_ID" NUMBER,

                "EXECUTIVE" VARCHAR2(240 BYTE),

                "CHIEF_ESTIMATOR" VARCHAR2(240 BYTE),

                "BOW_MANAGER" VARCHAR2(240 BYTE),

                "COORDINATOR" VARCHAR2(240 BYTE),

                "REGION" VARCHAR2(50 BYTE),

                "SECTOR" VARCHAR2(100 BYTE),

                "NUMBER_FLOORS" NUMBER,

                "NUMBER_BUILDINGS" NUMBER,

                "BPM_DELIVERY_METHOD" VARCHAR2(50 BYTE),

                "INSURANCE" VARCHAR2(50 BYTE),

                "BONDING" VARCHAR2(50 BYTE),

                "PAYROLL_REQUIREMENTS" VARCHAR2(50 BYTE),

                "GREEN_BLDG_CERT" VARCHAR2(50 BYTE),

                "MBE_CERT_TYPE" VARCHAR2(150 BYTE),

                "MBE_PARTICIPATION" NUMBER,

                "HUD_FLG" CHAR(1 BYTE),

                "MUNICIPALITY" VARCHAR2(100 BYTE),

                "POWER_COMPANY" VARCHAR2(100 BYTE),

                "UNIT_WIRING_METHOD" VARCHAR2(50 BYTE),

                "BID_METHOD" VARCHAR2(50 BYTE),

                "CODE_DATA" VARCHAR2(50 BYTE),

                "AWARDED_DATE" DATE,

                "CONEST_GP" NUMBER,

                "AGREEMENT_NUM" VARCHAR2(50 BYTE),

                "AGREEMENT_TYPE" VARCHAR2(30 BYTE),

                "ICT_TYPE" VARCHAR2(150 BYTE),

                "LABOR_HOURS" NUMBER,

                "BILLING_CYCLE_NAME" VARCHAR2(720 BYTE),

                "PDR_IPO_FLAG" CHAR(1 BYTE),

                "FA_IPO_FLAG" CHAR(1 BYTE),

                "LV_IPO_FLAG" CHAR(1 BYTE),

                "PDI_SERVICE_NARRATIVE" VARCHAR2(1000 BYTE),

                "PDI_SERVICE_AFFILIATION" VARCHAR2(150 BYTE),

                "PDI_SERVICE_CAP" NUMBER(22,5),

                "PDI_SERVICE_WORK_REQUESTED_BY" VARCHAR2(150 BYTE),

                "CONEST_ESTIMATOR" VARCHAR2(240 BYTE)

                 )

               

               

              1. The SQL and a short description of its purpose

               

              WITH all_holds AS

                (SELECT NVL(

                  (SELECT dom

                  FROM apps.xxdw_tasks_dim xtd,

                    apps.ap_invoice_distributions_all aid

                  WHERE xtd.project_id = aid.project_id

                  AND aid.invoice_id   = ai.invoice_id

                  AND ROWNUM           < 2

                  AND nvl(AID.REVERSAL_FLAG, 'N') = 'N' -- DR

                  ),

                  (SELECT dom

                  FROM apps.xxdw_tasks_dim xtd,

                    apps.ap_invoice_distributions_all aid,

                    apps.po_distributions_all pod

                  WHERE xtd.project_id       = pod.project_id

                  AND pod.po_distribution_id = aid.po_distribution_id

                  AND aid.invoice_id         = ai.invoice_id

                  AND ROWNUM                 < 2

                  AND nvl(AID.REVERSAL_FLAG, 'N') = 'N'  -- DR

                  )) dom,

                  NVL(

                  (SELECT project_manager

                  FROM apps.xxdw_tasks_dim xtd,

                    apps.ap_invoice_distributions_all aid

                  WHERE xtd.project_id = aid.project_id

                  AND aid.invoice_id   = ai.invoice_id

                  AND ROWNUM           < 2

                  AND nvl(AID.REVERSAL_FLAG, 'N') = 'N' -- DR

                  ),

                  (SELECT project_manager

                  FROM apps.xxdw_tasks_dim xtd,

                    apps.ap_invoice_distributions_all aid,

                    apps.po_distributions_all pod

                  WHERE xtd.project_id       = pod.project_id

                  AND pod.po_distribution_id = aid.po_distribution_id

                  AND aid.invoice_id         = ai.invoice_id

                  AND ROWNUM                 < 2

                  AND nvl(AID.REVERSAL_FLAG, 'N') = 'N'  -- DR

                  )) pm,

                  ppa.project_id,

                  ppa.project_name project,

                  ppa.project_number,

                  ppa.project_executive,

                  ppa.project_engineer,

                  ppa.apm,

                  pv.vendor_name,

                  pv.vendor_type_lookup_code vendor_type,

                  (SELECT ap_emp.full_name

                  FROM apps.per_all_people_f ap_emp

                  WHERE pv.attribute1 = ap_emp.person_id

                  AND SYSDATE BETWEEN ap_emp.effective_start_date AND ap_emp.effective_end_date

                  ) ap_employee,

                  ai.invoice_num,

                  ai.invoice_id,

                  (SELECT MIN (Least (NVL (discount_date, due_date), due_date))

                  FROM apps.ap_payment_schedules_all aps

                  WHERE aps.invoice_id = ai.invoice_id

                  ) due_date,

                  (SELECT MIN (Least (NVL (discount_date, due_date), due_date))

                  FROM apps.ap_payment_schedules_all aps

                  WHERE aps.invoice_id = ai.invoice_id

                  ) due_date_display,

                  ai.invoice_date,

                  ai.pay_group_lookup_code,--added by RV080715

                  ai.invoice_amount,

                  ai.description invoice_description,

                  apps.xxpdi_obiee_pkg.Get_po_number (ai.invoice_num, pv.vendor_name) po_number,

                  (SELECT line_num

                  FROM apps.po_lines_all pl,

                    apps.po_line_locations_all pll

                  WHERE pll.po_line_id     = pl.po_line_id

                  AND pll.line_location_id = ah.line_location_id

                  ) po_line_number,

                  (SELECT seq_no

                  FROM apps.xxpd_bom_lines xbl,

                    apps.po_line_locations_all pll

                  WHERE pll.line_location_id     = ah.line_location_id

                  AND To_number(pll.attribute15) = xbl.line_id

                  ) cbom_line_number,

                  ah.hold_reason,

                  ah.hold_date,

                  comm_info.last_comment_date,   

                  apex_item.Hidden (1, ah.hold_id)

                  || xxext.xxext_ap_inv_apex_wrp.Func_show_comments(ah.hold_id, xxext.xxext_ap_inv_apex_wrp.Is_ap_view(:APP_USER), 0, 'AP', null, 100)

                  || '<div class="btnWrapper">'

                  || '<a id="addComments_'

                  || ah.hold_id

                  || '" class="btn_add" onclick="return false;" href="f?p='

                  ||:APP_ID

                  ||':11:'

                  ||:APP_SESSION

                  ||':::11:P11_HOLD_ID,P11_WAITING_ON,P11_COMMENT_TYPE:'

                  || ah.hold_id

                  || ','

                  ||

                  CASE

                    WHEN :F_IS_AP = 1

                    THEN 'PM'

                    ELSE 'AP'

                  END

                  ||','

                  ||

                  CASE

                    WHEN :F_IS_AP = 1

                    THEN 'AP'

                    WHEN :F_IS_LPM = 1

                    THEN 'LPM'

                    ELSE 'PM'

                  END

                  ||'"><button type="button" class="button-default" '

                  ||' onclick="return false;" > '

                  ||'<span>Add Comment</span></button></a>'

                  ||

                  CASE

                  WHEN NVL(comm_info.nb_comments, 0 ) > 0

                  THEN

                   '<a id="addShowAll_'

                      || ah.hold_id

                      || '" class="btn_showall" onclick="return false;" href="f?p='

                      ||:APP_ID

                      ||':12:'

                      ||:APP_SESSION

                      || ':::12:P12_HOLD_ID,P12_PROV_VIEW:'

                      || ah.hold_id

                      || ',AP'

                      || '"><button type="button" class="button-default" '

                      ||' onclick="return false;" > '

                      || '<span>Show All ' || case

                                                  when comm_info.nb_comments > 0 then

                                                     '(' || comm_info.nb_comments || ')'

                                              end

                                           ||

                        '</span></button></a>'

                 END

                  ||'</div>' comments_html,

                  xxext.xxext_ap_inv_apex_wrp.Func_show_comments(ah.hold_id, xxext.xxext_ap_inv_apex_wrp.Is_ap_view(:APP_USER), 0, 'AP', 1) comments_no_html,

                  CASE

                    WHEN :F_IS_AP = 1

                    THEN apex_item.Select_list(p_idx => 1, p_value => NVL(ac.hold_value, NVL(ah.attribute3, 'Waiting on AP') ), p_list_values => 'AP;Waiting on AP,PM;Waiting on PM', p_attributes => ' class="holds-waiting-on holds-item-field waitingon-'

                      ||NVL(ac.hold_value, Trim(REPLACE(Upper(NVL(ah.attribute3, 'Waiting on AP')), 'WAITING ON', '')))

                      ||'" '

                      ||' data-seq_id="'

                      ||ac.seq_id

                      ||'" '

                      ||' data-hold_id="'

                      ||ah.hold_id

                      ||'" '

                      ||' data-attr_number="1" ', p_show_null => 'NO')

                    ELSE Trim(REPLACE(Upper(NVL(ah.attribute3, 'Waiting on AP')), 'WAITING ON', '' ))

                  END waiting_on

                FROM apps.ap_invoices_all ai,

                  apps.ap_holds_all ah,

                  xxext.xxext_ap_holds_all_views_v ah_v,

                  apps.po_vendors pv,

                  (SELECT seq_id,

                    n001 hold_id,

                    c001 hold_value

                  FROM apex_collections

                  WHERE collection_name = 'ALL_HOLDS'

                  ) ac,

                  (SELECT hold_id,

                    COUNT(*) nb_comments,

                    MAX(creation_date) last_comment_date

                  FROM xxext.xxext_ap_holds_comments

                  GROUP BY hold_id

                  ) comm_info,

                  (SELECT DISTINCT ppa.name project_name,

                    ppa.segment1 project_number,

                    ppa.project_id,

                    aid.invoice_id,

                    (SELECT First_value(papf.full_name) over ( PARTITION BY ppa.name ORDER BY ppp.start_date_active DESC) project_executive

                    FROM apps.pa_project_role_types_tl prt,

                      apps.per_all_people_f papf,

                      apps.pa_project_parties ppp

                    WHERE ppp.project_id = ppa.project_id

                    AND SYSDATE BETWEEN ppp.start_date_active AND NVL(ppp.end_date_active, To_date('31-DEC-4712', 'DD-MON-RRRR'))

                    AND ppp.project_role_id = prt.project_role_id

                    AND prt.meaning         = 'PDI Project Executive'

                    AND papf.person_id      = ppp.resource_source_id

                    AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date

                    AND ROWNUM < 2

                    ) project_executive,

                    (SELECT First_value(papf.full_name) over ( PARTITION BY ppa.name ORDER BY ppp.start_date_active DESC) project_executive

                    FROM apps.pa_project_role_types_tl prt,

                      apps.per_all_people_f papf,

                      apps.pa_project_parties ppp

                    WHERE ppp.project_id = ppa.project_id

                    AND SYSDATE BETWEEN ppp.start_date_active AND NVL(ppp.end_date_active, To_date('31-DEC-4712', 'DD-MON-RRRR'))

                    AND ppp.project_role_id = prt.project_role_id

                    AND Upper(prt.meaning) LIKE '%PROJECT ENGINEER%'

                    AND papf.person_id = ppp.resource_source_id

                    AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date

                    AND ROWNUM < 2

                    ) project_engineer,

                    (SELECT First_value(papf.full_name) over ( PARTITION BY ppa.name ORDER BY ppp.start_date_active DESC) project_executive

                    FROM apps.pa_project_role_types_tl prt,

                      apps.per_all_people_f papf,

                      apps.pa_project_parties ppp

                    WHERE ppp.project_id = ppa.project_id

                    AND SYSDATE BETWEEN ppp.start_date_active AND NVL(ppp.end_date_active, To_date('31-DEC-4712', 'DD-MON-RRRR'))

                    AND ppp.project_role_id = prt.project_role_id

                    AND Upper(prt.meaning) LIKE '%PDI ASST PROJECT MANAGER%'

                    AND papf.person_id = ppp.resource_source_id

                    AND SYSDATE BETWEEN papf.effective_start_date AND papf.effective_end_date

                    AND ROWNUM < 2

                    ) apm

                  FROM apps.pa_projects_all ppa,

                    apps.ap_invoice_distributions_all aid,

                    apps.po_distributions_all pod

                  WHERE ppa.project_id            = NVL(pod.project_id, aid.project_id)

                  AND pod.po_distribution_id(+)   = aid.po_distribution_id

                  AND NVL(aid.reversal_flag, 'N') = 'N'

                    -- fix to prevent discarded lines being picked resulting in duplicate data in holds view

                  AND NOT EXISTS

                    (SELECT 1

                    FROM apps.ap_invoice_lines_all ail

                    WHERE ail.invoice_id             = aid.invoice_id

                    AND ail.line_number              = aid.invoice_line_number

                    AND NVL(ail.discarded_flag, 'N') = 'Y'

                    )

                  ) ppa

                WHERE ah.invoice_id         = ai.invoice_id

                AND pv.vendor_id            = ai.vendor_id

                AND ac.hold_id(+)           = ah.hold_id

                AND ah.release_lookup_code IS NULL

                AND ah_v.hold_id            = ah.hold_id

                AND comm_info.hold_id(+)    = ah.hold_id

                AND ppa.invoice_id(+)       = ai.invoice_id

                )

              SELECT DISTINCT a.dom,

                a.pm,

                a.project,

                a.project_number,

                a.project_executive,

                a.project_engineer,

                a.apm,

                a.vendor_name,

                a.vendor_type,

                a.invoice_num,

                a.invoice_id,

                a.due_date,

                CASE

                  WHEN SYSDATE > a.due_date_display - 7

                  AND SYSDATE  < a.due_date_display

                  THEN '<span style="background-color:#FFFF99;">'

                    || TO_CHAR(a.due_date_display, :DATE_FORMAT)

                    ||'</span>'

                  WHEN SYSDATE > a.due_date_display

                  THEN '<span style="background-color:#FF7755;">'

                    || TO_CHAR(a.due_date_display, :DATE_FORMAT)

                    ||'</span>'

                  ELSE TO_CHAR(a.due_date_display, :DATE_FORMAT)

                END due_date_display,

                a.invoice_date,

                a.invoice_amount,

                a.invoice_description,

                a.pay_group_lookup_code,

                a.po_number,

                a.po_line_number,

                a.hold_reason,

                a.hold_date,

                a.last_comment_date,

                a.comments_html,

                a.comments_no_html,

                a.waiting_on,

                CASE

                  WHEN a.po_number = 'None'

                  THEN 'None'

                  ELSE TO_CHAR(apps.xxpdi_obiee_pkg.Get_cbom_number(a.po_number))

                END cbom_no,

                a.cbom_line_number,

                a.ap_employee

              FROM

                (SELECT ah.dom,

                  ah.pm,

                  ah.project,

                  ah.project_number,

                  ah.project_executive,

                  ah.project_engineer,

                  ah.apm,

                  ah.vendor_name,

                  ah.vendor_type,

                  ah.invoice_num,

                  ah.invoice_id,

                  ah.due_date,

                  ah.due_date_display,

                  ah.invoice_date,

                  ah.invoice_amount,

                  ah.invoice_description,

                  ah.pay_group_lookup_code,

                  ah.po_number,

                  ah.po_line_number,

                  ah.hold_reason,

                  ah.hold_date,

                  ah.last_comment_date,

                  ah.comments_html,

                  ah.comments_no_html,

                  ah.waiting_on,

                  ah.cbom_line_number,

                  ah.ap_employee

                FROM all_holds ah

                WHERE ( ah.project_id IS NULL

                AND :F_IS_AP           = 1 )

                OR ( ah.project_id    IS NOT NULL

                AND ( :F_IS_AP         = 1

                OR :F_IS_LPM           = 1 ) )

                OR ( ah.project_id    IN

                  (SELECT prj.project_id

                  FROM apps.pa_secured_projects_v prj

                  WHERE NOT EXISTS

                    (SELECT 1

                    FROM apps.xxpdi_regions_v reg

                    WHERE Upper(reg.rvp) = Upper ( :F_USER_NAME)

                    )

                  UNION

                  SELECT prj.project_id

                  FROM xxdw.xxdw_projects_dtl prj,

                    apps.xxpdi_regions_v reg

                  WHERE Upper(reg.region)            = Upper(prj.carrying_out_organization)

                  AND ( Upper(prj.project_executive) = Upper(:F_USER_NAME)

                  OR Upper(reg.rvp)                  = Upper( :F_USER_NAME) )

                  ) )

                ) A

              ORDER BY 2,

                3,

                4,

                5,

                6;

               

              All Rows Fetched: 539 in 296.834 seconds

               

              2. The version of your database with 4-digits (e.g. 10.2.0.4)

               

              12.1.0.2.0

               

              3. Optimizer related parameters

               

              Where do I check this?

               

              4. The TIMING and AUTOTRACE output

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

               

              ---------------------------------------------------------------------------------------------------------------------------------------

              | Id  | Operation                                               | Name                           | Rows  | Bytes |TempSpc| Cost (%CPU)|

              ---------------------------------------------------------------------------------------------------------------------------------------

              |   0 | SELECT STATEMENT                                        |                                |     1 |   728 |       |   308M  (5)|

              |*  1 |  COUNT STOPKEY                                          |                                |       |       |       |            |

              |   2 |   NESTED LOOPS                                          |                                |  1684 | 65676 |       |   352   (0)|

              |   3 |    NESTED LOOPS                                         |                                |  1740 | 65676 |       |   352   (0)|

              |*  4 |     TABLE ACCESS BY INDEX ROWID BATCHED                 | AP_INVOICE_DISTRIBUTIONS_ALL   |    15 |   195 |       |     7   (0)|

              |*  5 |      INDEX RANGE SCAN                                   | AP_INVOICE_DISTRIBUTIONS_N27   |    24 |       |       |     3   (0)|

              |*  6 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |   116 |       |       |     2   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |   7 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |   113 |  2938 |       |    23   (0)|

              |*  8 |  COUNT STOPKEY                                          |                                |       |       |       |            |

              |   9 |   NESTED LOOPS                                          |                                |  1134 | 56700 |       |   257   (0)|

              |  10 |    NESTED LOOPS                                         |                                |  1160 | 56700 |       |   257   (0)|

              |  11 |     NESTED LOOPS                                        |                                |    10 |   240 |       |    27   (0)|

              |* 12 |      TABLE ACCESS BY INDEX ROWID BATCHED                | AP_INVOICE_DISTRIBUTIONS_ALL   |    10 |   130 |       |     7   (0)|

              |* 13 |       INDEX RANGE SCAN                                  | AP_INVOICE_DISTRIBUTIONS_N27   |    24 |       |       |     3   (0)|

              |  14 |      TABLE ACCESS BY INDEX ROWID                        | PO_DISTRIBUTIONS_ALL           |     1 |    11 |       |     2   (0)|

              |* 15 |       INDEX UNIQUE SCAN                                 | PO_DISTRIBUTIONS_U1            |     1 |       |       |     1   (0)|

              |* 16 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |   116 |       |       |     2   (0)|

              |  17 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |   115 |  2990 |       |    23   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |* 18 |  COUNT STOPKEY                                          |                                |       |       |       |            |

              |  19 |   NESTED LOOPS                                          |                                |  1684 | 62308 |       |   352   (0)|

              |  20 |    NESTED LOOPS                                         |                                |  1740 | 62308 |       |   352   (0)|

              |* 21 |     TABLE ACCESS BY INDEX ROWID BATCHED                 | AP_INVOICE_DISTRIBUTIONS_ALL   |    15 |   195 |       |     7   (0)|

              |* 22 |      INDEX RANGE SCAN                                   | AP_INVOICE_DISTRIBUTIONS_N27   |    24 |       |       |     3   (0)|

              |* 23 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |   116 |       |       |     2   (0)|

              |  24 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |   113 |  2712 |       |    23   (0)|

              |* 25 |  COUNT STOPKEY                                          |                                |       |       |       |            |

              |  26 |   NESTED LOOPS                                          |                                |  1134 | 54432 |       |   257   (0)|

              |  27 |    NESTED LOOPS                                         |                                |  1160 | 54432 |       |   257   (0)|

              |  28 |     NESTED LOOPS                                        |                                |    10 |   240 |       |    27   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |* 29 |      TABLE ACCESS BY INDEX ROWID BATCHED                | AP_INVOICE_DISTRIBUTIONS_ALL   |    10 |   130 |       |     7   (0)|

              |* 30 |       INDEX RANGE SCAN                                  | AP_INVOICE_DISTRIBUTIONS_N27   |    24 |       |       |     3   (0)|

              |  31 |      TABLE ACCESS BY INDEX ROWID                        | PO_DISTRIBUTIONS_ALL           |     1 |    11 |       |     2   (0)|

              |* 32 |       INDEX UNIQUE SCAN                                 | PO_DISTRIBUTIONS_U1            |     1 |       |       |     1   (0)|

              |* 33 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |   116 |       |       |     2   (0)|

              |  34 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |   115 |  2760 |       |    23   (0)|

              |  35 |  WINDOW SORT                                            |                                |     1 |    87 |       |    10  (10)|

              |* 36 |   COUNT STOPKEY                                         |                                |       |       |       |            |

              |  37 |    NESTED LOOPS                                         |                                |     1 |    87 |       |     9   (0)|

              |  38 |     NESTED LOOPS                                        |                                |     2 |    87 |       |     9   (0)|

              |  39 |      NESTED LOOPS                                       |                                |     1 |    50 |       |     5   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |  40 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_ROLE_TYPES_TL       |     1 |    27 |       |     2   (0)|

              |* 41 |        INDEX RANGE SCAN                                 | PA_PROJECT_ROLE_TYPES_TL_U2    |     1 |       |       |     1   (0)|

              |* 42 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |     1 |    23 |       |     3   (0)|

              |* 43 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_N1          |     4 |       |       |     1   (0)|

              |* 44 |      INDEX RANGE SCAN                                   | PER_PEOPLE_F_PK                |     2 |       |       |     1   (0)|

              |  45 |     TABLE ACCESS BY INDEX ROWID                         | PER_ALL_PEOPLE_F               |     1 |    37 |       |     4   (0)|

              |  46 |  WINDOW SORT                                            |                                |     1 |    87 |       |    26   (4)|

              |* 47 |   COUNT STOPKEY                                         |                                |       |       |       |            |

              |  48 |    NESTED LOOPS                                         |                                |     4 |   348 |       |    25   (0)|

              |  49 |     NESTED LOOPS                                        |                                |     6 |   348 |       |    25   (0)|

              |  50 |      NESTED LOOPS                                       |                                |     3 |   150 |       |    13   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |* 51 |       TABLE ACCESS FULL                                 | PA_PROJECT_ROLE_TYPES_TL       |     3 |    81 |       |     6   (0)|

              |* 52 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |     1 |    23 |       |     3   (0)|

              |* 53 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_N1          |     4 |       |       |     1   (0)|

              |* 54 |      INDEX RANGE SCAN                                   | PER_PEOPLE_F_PK                |     2 |       |       |     1   (0)|

              |  55 |     TABLE ACCESS BY INDEX ROWID                         | PER_ALL_PEOPLE_F               |     1 |    37 |       |     4   (0)|

              |  56 |  WINDOW SORT                                            |                                |     1 |    87 |       |    26   (4)|

              |* 57 |   COUNT STOPKEY                                         |                                |       |       |       |            |

              |  58 |    NESTED LOOPS                                         |                                |     4 |   348 |       |    25   (0)|

              |  59 |     NESTED LOOPS                                        |                                |     6 |   348 |       |    25   (0)|

              |  60 |      NESTED LOOPS                                       |                                |     3 |   150 |       |    13   (0)|

              |* 61 |       TABLE ACCESS FULL                                 | PA_PROJECT_ROLE_TYPES_TL       |     3 |    81 |       |     6   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |* 62 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |     1 |    23 |       |     3   (0)|

              |* 63 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_N1          |     4 |       |       |     1   (0)|

              |* 64 |      INDEX RANGE SCAN                                   | PER_PEOPLE_F_PK                |     2 |       |       |     1   (0)|

              |  65 |     TABLE ACCESS BY INDEX ROWID                         | PER_ALL_PEOPLE_F               |     1 |    37 |       |     4   (0)|

              |  66 |  SORT AGGREGATE                                         |                                |     1 |    18 |       |            |

              |  67 |   TABLE ACCESS BY INDEX ROWID BATCHED                   | AP_PAYMENT_SCHEDULES_ALL       |     1 |    18 |       |     4   (0)|

              |* 68 |    INDEX RANGE SCAN                                     | AP_PAYMENT_SCHEDULES_U1        |     1 |       |       |     3   (0)|

              |  69 |  SORT AGGREGATE                                         |                                |     1 |    18 |       |            |

              |  70 |   TABLE ACCESS BY INDEX ROWID BATCHED                   | AP_PAYMENT_SCHEDULES_ALL       |     1 |    18 |       |     4   (0)|

              |* 71 |    INDEX RANGE SCAN                                     | AP_PAYMENT_SCHEDULES_U1        |     1 |       |       |     3   (0)|

              |  72 |  NESTED LOOPS                                           |                                |     1 |    22 |       |     5   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |  73 |   TABLE ACCESS BY INDEX ROWID                           | PO_LINE_LOCATIONS_ALL          |     1 |    12 |       |     3   (0)|

              |* 74 |    INDEX UNIQUE SCAN                                    | PO_LINE_LOCATIONS_U1           |     1 |       |       |     2   (0)|

              |  75 |   TABLE ACCESS BY INDEX ROWID                           | PO_LINES_ALL                   |     1 |    10 |       |     2   (0)|

              |* 76 |    INDEX UNIQUE SCAN                                    | PO_LINES_U1                    |     1 |       |       |     1   (0)|

              |  77 |  NESTED LOOPS                                           |                                |     1 |    22 |       |     5   (0)|

              |  78 |   TABLE ACCESS BY INDEX ROWID                           | PO_LINE_LOCATIONS_ALL          |     1 |    13 |       |     3   (0)|

              |* 79 |    INDEX UNIQUE SCAN                                    | PO_LINE_LOCATIONS_U1           |     1 |       |       |     2   (0)|

              |  80 |   TABLE ACCESS BY INDEX ROWID                           | XXPD_BOM_LINES                 |     1 |     9 |       |     2   (0)|

              |* 81 |    INDEX UNIQUE SCAN                                    | SYS_C00262182                  |     1 |       |       |     1   (0)|

              |  82 |  TABLE ACCESS BY INDEX ROWID BATCHED                    | PER_ALL_PEOPLE_F               |     2 |    74 |       |     4   (0)|

              |* 83 |   INDEX RANGE SCAN                                      | PER_PEOPLE_F_PK                |     2 |       |       |     1   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |  84 |  SORT UNIQUE                                            |                                |     1 |   728 |       |   308M  (5)|

              |* 85 |   FILTER                                                |                                |       |       |       |            |

              |* 86 |    HASH JOIN OUTER                                      |                                |  2407 |  1711K|       |   308M  (5)|

              |  87 |     JOIN FILTER CREATE                                  | :BF0000                        |   408 |   121K|       |  9672   (3)|

              |* 88 |      HASH JOIN OUTER                                    |                                |   408 |   121K|       |  9672   (3)|

              |  89 |       JOIN FILTER CREATE                                | :BF0001                        |   273 | 76167 |       |  9426   (3)|

              |  90 |        NESTED LOOPS                                     |                                |   273 | 76167 |       |  9426   (3)|

              |* 91 |         HASH JOIN                                       |                                |   273 | 74802 |       |  9426   (3)|

              |  92 |          NESTED LOOPS                                   |                                |   273 | 61698 |       |  9356   (3)|

              |  93 |           NESTED LOOPS                                  |                                |   273 | 61698 |       |  9356   (3)|

              |* 94 |            HASH JOIN                                    |                                |   273 | 43680 |       |  8809   (3)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |* 95 |             HASH JOIN RIGHT OUTER                       |                                |   273 | 26754 |       |  3662   (1)|

              |  96 |              VIEW                                       |                                |     1 |    11 |       |    48   (0)|

              |  97 |               NESTED LOOPS                              |                                |     1 |    79 |       |    46   (0)|

              |  98 |                NESTED LOOPS                             |                                |   252 |    79 |       |    46   (0)|

              |  99 |                 NESTED LOOPS                            |                                |     1 |    59 |       |    33   (0)|

              |*100 |                  COUNT STOPKEY                          |                                |       |       |       |            |

              | 101 |                   FAST DUAL                             |                                |     1 |       |       |     2   (0)|

              | 102 |                  VIEW                                   | WWV_FLOW_CURRENT_SGID          |     1 |    13 |       |    31   (0)|

              |*103 |                   COUNT STOPKEY                         |                                |       |       |       |            |

              | 104 |                    COLLECTION ITERATOR CONSTRUCTOR FETCH|                                |     1 |       |       |    29   (0)|

              | 105 |                  TABLE ACCESS BY INDEX ROWID BATCHED    | WWV_FLOW_COLLECTIONS$          |     1 |    46 |       |     2   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |*106 |                   INDEX RANGE SCAN                      | WWV_FLOW_COLLECTIONS_UK        |     1 |       |       |     1   (0)|

              | 107 |                    FAST DUAL                            |                                |     1 |       |       |     2   (0)|

              | 108 |                    FAST DUAL                            |                                |     1 |       |       |     2   (0)|

              |*109 |                 INDEX RANGE SCAN                        | WWV_FLOW_COLLECTION_MEMBERS_PK |   252 |       |       |     4   (0)|

              | 110 |                TABLE ACCESS BY INDEX ROWID              | WWV_FLOW_COLLECTION_MEMBERS$   |   252 |  5040 |       |    13   (0)|

              | 111 |              TABLE ACCESS BY INDEX ROWID BATCHED        | AP_HOLDS_ALL                   |   273 | 23751 |       |  3613   (1)|

              |*112 |               INDEX SKIP SCAN                           | AP_HOLDS_N1                    |   273 |       |       |  3578   (1)|

              | 113 |             TABLE ACCESS FULL                           | AP_HOLDS_ALL                   |   787K|    46M|       |  5138   (5)|

              |*114 |            INDEX UNIQUE SCAN                            | AP_INVOICES_U1                 |     1 |       |       |     1   (0)|

              | 115 |           TABLE ACCESS BY INDEX ROWID                   | AP_INVOICES_ALL                |     1 |    66 |       |     2   (0)|

              | 116 |          TABLE ACCESS FULL                              | AP_SUPPLIERS                   |  4947 |   231K|       |    70   (3)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |*117 |         INDEX UNIQUE SCAN                               | HZ_PARTIES_U1                  |     1 |     5 |       |     0   (0)|

              | 118 |       VIEW                                              |                                | 26747 |   705K|       |   246   (4)|

              | 119 |        HASH GROUP BY                                    |                                | 26747 |   339K|       |   246   (4)|

              | 120 |         JOIN FILTER USE                                 | :BF0001                        | 44500 |   564K|       |   241   (2)|

              |*121 |          TABLE ACCESS FULL                              | XXEXT_AP_HOLDS_COMMENTS        | 44500 |   564K|       |   241   (2)|

              | 122 |     VIEW                                                |                                |  4709K|  1895M|       |   308M  (5)|

              | 123 |      HASH UNIQUE                                        |                                |  4709K|   336M|   399M|   308M  (5)|

              |*124 |       FILTER                                            |                                |       |       |       |            |

              | 125 |        JOIN FILTER USE                                  | :BF0000                        |  4709K|   336M|       |   121K  (4)|

              |*126 |         HASH JOIN                                       |                                |  4709K|   336M|       |   121K  (4)|

              | 127 |          TABLE ACCESS FULL                              | PA_PROJECTS_ALL                |  3545 |   145K|       |    96   (3)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |*128 |          HASH JOIN RIGHT OUTER                          |                                |  4709K|   148M|    38M|   121K  (4)|

              | 129 |           INDEX FULL SCAN                               | PO_DISTRIBUTIONS_N15           |  1776K|    18M|       | 12223   (1)|

              |*130 |           TABLE ACCESS FULL                             | AP_INVOICE_DISTRIBUTIONS_ALL   |  3738K|    78M|       | 99593   (4)|

              |*131 |        TABLE ACCESS BY INDEX ROWID                      | AP_INVOICE_LINES_ALL           |     1 |    12 |       |     3   (0)|

              |*132 |         INDEX UNIQUE SCAN                               | AP_INVOICE_LINES_U1            |     1 |       |       |     2   (0)|

              |*133 |    TABLE ACCESS BY INDEX ROWID BATCHED                  | AP_HOLDS_ALL                   |     1 |    67 |       |     4   (0)|

              |*134 |     INDEX RANGE SCAN                                    | AP_HOLDS_N1                    |     1 |       |       |     3   (0)|

              |*135 |    TABLE ACCESS BY INDEX ROWID BATCHED                  | AP_HOLDS_ALL                   |     1 |    67 |       |     4   (0)|

              |*136 |     INDEX RANGE SCAN                                    | AP_HOLDS_N1                    |     1 |       |       |     3   (0)|

              |*137 |    TABLE ACCESS BY INDEX ROWID BATCHED                  | AP_HOLDS_ALL                   |     1 |    67 |       |     4   (0)|

              |*138 |     INDEX RANGE SCAN                                    | AP_HOLDS_N1                    |     1 |       |       |     3   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              | 139 |    SORT UNIQUE                                          |                                |     2 |   158 |       |   124   (3)|

              | 140 |     UNION-ALL                                           |                                |       |       |       |            |

              |*141 |      FILTER                                             |                                |       |       |       |            |

              |*142 |       FILTER                                            |                                |       |       |       |            |

              | 143 |        NESTED LOOPS                                     |                                |     1 |    19 |       |     4   (0)|

              | 144 |         TABLE ACCESS BY INDEX ROWID                     | FND_USER                       |     1 |     8 |       |     2   (0)|

              |*145 |          INDEX UNIQUE SCAN                              | FND_USER_U1                    |     1 |       |       |     1   (0)|

              |*146 |         TABLE ACCESS BY INDEX ROWID BATCHED             | PA_PROJECTS_ALL                |     1 |    11 |       |     2   (0)|

              |*147 |          INDEX RANGE SCAN                               | PA_PROJECTS_U1                 |     1 |       |       |     1   (0)|

              |*148 |        TABLE ACCESS FULL                                | HR_ALL_ORGANIZATION_UNITS      |     1 |    13 |       |     6   (0)|

              |*149 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |     1 |    30 |       |     3   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |*150 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_U2          |     1 |       |       |     2   (0)|

              | 151 |       NESTED LOOPS                                      |                                |     1 |    92 |       |     4   (0)|

              | 152 |        TABLE ACCESS BY INDEX ROWID                      | FND_OBJECTS                    |     1 |    46 |       |     2   (0)|

              |*153 |         INDEX UNIQUE SCAN                               | FND_OBJECTS_U2                 |     1 |       |       |     1   (0)|

              |*154 |        TABLE ACCESS BY INDEX ROWID BATCHED              | FND_GRANTS                     |     1 |    46 |       |     2   (0)|

              |*155 |         INDEX RANGE SCAN                                | FND_GRANTS_N1                  |     1 |       |       |     1   (0)|

              |*156 |      HASH JOIN                                          |                                |     1 |    60 |       |   112   (1)|

              |*157 |       HASH JOIN OUTER                                   |                                |     1 |    31 |       |   105   (0)|

              |*158 |        TABLE ACCESS FULL                                | XXDW_PROJECTS_DTL_T            |     1 |    26 |       |    86   (0)|

              | 159 |        VIEW                                             |                                |     1 |     5 |       |    19   (0)|

              |*160 |         INDEX RANGE SCAN                                | XXDW_PROJECT_SUMMARY_N1        |     1 |    13 |       |     3   (0)|

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              |*161 |          TABLE ACCESS FULL                              | XXDW_PERIODS_DIM               |     1 |    10 |       |     5   (0)|

              |*162 |       TABLE ACCESS FULL                                 | HR_ALL_ORGANIZATION_UNITS      |     5 |   145 |       |     6   (0)|

              ---------------------------------------------------------------------------------------------------------------------------------------

               

              Predicate Information (identified by operation id):

              ---------------------------------------------------

               

                 1 - filter(ROWNUM<2)

                 4 - filter(NVL("AID"."REVERSAL_FLAG",'N')='N')

                 5 - access("AID"."INVOICE_ID"=:B1)

                 6 - access("PROJECT_ID"="AID"."PROJECT_ID")

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                 8 - filter(ROWNUM<2)

                12 - filter("AID"."PO_DISTRIBUTION_ID" IS NOT NULL AND NVL("AID"."REVERSAL_FLAG",'N')='N')

                13 - access("AID"."INVOICE_ID"=:B1)

                15 - access("POD"."PO_DISTRIBUTION_ID"="AID"."PO_DISTRIBUTION_ID")

                16 - access("PROJECT_ID"="POD"."PROJECT_ID")

                18 - filter(ROWNUM<2)

                21 - filter(NVL("AID"."REVERSAL_FLAG",'N')='N')

                22 - access("AID"."INVOICE_ID"=:B1)

                23 - access("PROJECT_ID"="AID"."PROJECT_ID")

                25 - filter(ROWNUM<2)

                29 - filter("AID"."PO_DISTRIBUTION_ID" IS NOT NULL AND NVL("AID"."REVERSAL_FLAG",'N')='N')

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                30 - access("AID"."INVOICE_ID"=:B1)

                32 - access("POD"."PO_DISTRIBUTION_ID"="AID"."PO_DISTRIBUTION_ID")

                33 - access("PROJECT_ID"="POD"."PROJECT_ID")

                36 - filter(ROWNUM<2)

                41 - access("PRT"."MEANING"='PDI Project Executive')

                42 - filter("PPP"."START_DATE_ACTIVE"<=SYSDATE@! AND NVL("PPP"."END_DATE_ACTIVE",TO_DATE(' 4712-12-31 00:00:00',

                            'syyyy-mm-dd hh24:mi:ss'))>=SYSDATE@!)

                43 - access("PPP"."PROJECT_ID"=:B1 AND "PPP"."PROJECT_ROLE_ID"="PRT"."PROJECT_ROLE_ID")

                44 - access("PAPF"."PERSON_ID"="PPP"."RESOURCE_SOURCE_ID" AND "PAPF"."EFFECTIVE_END_DATE">=SYSDATE@! AND

                            "PAPF"."EFFECTIVE_START_DATE"<=SYSDATE@!)

                     filter("PAPF"."EFFECTIVE_END_DATE">=SYSDATE@!)

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                47 - filter(ROWNUM<2)

                51 - filter(UPPER("PRT"."MEANING") LIKE '%PROJECT ENGINEER%')

                52 - filter("PPP"."START_DATE_ACTIVE"<=SYSDATE@! AND NVL("PPP"."END_DATE_ACTIVE",TO_DATE(' 4712-12-31 00:00:00',

                            'syyyy-mm-dd hh24:mi:ss'))>=SYSDATE@!)

                53 - access("PPP"."PROJECT_ID"=:B1 AND "PPP"."PROJECT_ROLE_ID"="PRT"."PROJECT_ROLE_ID")

                54 - access("PAPF"."PERSON_ID"="PPP"."RESOURCE_SOURCE_ID" AND "PAPF"."EFFECTIVE_END_DATE">=SYSDATE@! AND

                            "PAPF"."EFFECTIVE_START_DATE"<=SYSDATE@!)

                     filter("PAPF"."EFFECTIVE_END_DATE">=SYSDATE@!)

                57 - filter(ROWNUM<2)

                61 - filter(UPPER("PRT"."MEANING") LIKE '%PDI ASST PROJECT MANAGER%')

                62 - filter("PPP"."START_DATE_ACTIVE"<=SYSDATE@! AND NVL("PPP"."END_DATE_ACTIVE",TO_DATE(' 4712-12-31 00:00:00',

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                            'syyyy-mm-dd hh24:mi:ss'))>=SYSDATE@!)

                63 - access("PPP"."PROJECT_ID"=:B1 AND "PPP"."PROJECT_ROLE_ID"="PRT"."PROJECT_ROLE_ID")

                64 - access("PAPF"."PERSON_ID"="PPP"."RESOURCE_SOURCE_ID" AND "PAPF"."EFFECTIVE_END_DATE">=SYSDATE@! AND

                            "PAPF"."EFFECTIVE_START_DATE"<=SYSDATE@!)

                     filter("PAPF"."EFFECTIVE_END_DATE">=SYSDATE@!)

                68 - access("APS"."INVOICE_ID"=:B1)

                71 - access("APS"."INVOICE_ID"=:B1)

                74 - access("PLL"."LINE_LOCATION_ID"=:B1)

                76 - access("PLL"."PO_LINE_ID"="PL"."PO_LINE_ID")

                79 - access("PLL"."LINE_LOCATION_ID"=:B1)

                81 - access("XBL"."LINE_ID"=TO_NUMBER("PLL"."ATTRIBUTE15"))

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                83 - access("AP_EMP"."PERSON_ID"=TO_NUMBER(:B1) AND "AP_EMP"."EFFECTIVE_END_DATE">=SYSDATE@! AND

                            "AP_EMP"."EFFECTIVE_START_DATE"<=SYSDATE@!)

                     filter("AP_EMP"."EFFECTIVE_END_DATE">=SYSDATE@!)

                85 - filter((("AH"."HOLD_REASON"='Approval Pending' OR "AH"."HOLD_REASON"='Credit Need RGA' OR "AH"."HOLD_REASON"='Credit

                            Needs Research' OR "AH"."HOLD_REASON"='Distribution account is invalid' OR "AH"."HOLD_REASON"='Freight Needs Approval' OR

                            "AH"."HOLD_REASON"='Invoice amount exceeded limit' OR "AH"."HOLD_REASON"='Invoice has invalid or missing PO number' OR

                            "AH"."HOLD_REASON"='Line does not contain enough data to produce distributions' OR "AH"."HOLD_REASON"='Line references a

                            skeleton Distribution Set' OR "AH"."HOLD_REASON"='Line references an inactive Distribution Set' OR "AH"."HOLD_REASON"='Lines

                            on inv not on PO' OR "AH"."HOLD_REASON"='Lot PO setup incorrectly' OR "AH"."HOLD_REASON"='Manually Held Retainage' OR

                            "AH"."HOLD_REASON"='Open RGA waiting on credit' OR "AH"."HOLD_REASON"='PO Cancelled' OR "AH"."HOLD_REASON"='PO To Wrong

                            Vendor' OR "AH"."HOLD_REASON"='PO has been over billed' OR "AH"."HOLD_REASON"='PO has not been approved' OR

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                            "AH"."HOLD_REASON"='PO is Complete' OR "AH"."HOLD_REASON"='PO is complete' OR "AH"."HOLD_REASON"='Project Hold' OR

                            "AH"."HOLD_REASON"='RGA Pending Credit' OR "AH"."HOLD_REASON"='Return invoice to vendor' OR "AH"."HOLD_REASON"='Subcontractor

                            cannot be paid until the customer pays' OR "AH"."HOLD_REASON"='Sum of invoice and exchange rate variances exceeds limit') OR 

                            NOT EXISTS (SELECT 0 FROM "APPS"."AP_HOLDS_ALL" "AHA" WHERE "AHA"."RELEASE_LOOKUP_CODE" IS NULL AND "AHA"."INVOICE_ID"=:B1 AND

                            ("AHA"."HOLD_REASON"='Invoice has invalid or missing PO number' OR "AHA"."HOLD_REASON"='Invoice is not matched to any PO' OR

                            "AHA"."HOLD_REASON"='Lines on inv not on PO' OR "AHA"."HOLD_REASON"='Lot PO setup incorrectly' OR "AHA"."HOLD_REASON"='PO

                            Cancelled' OR "AHA"."HOLD_REASON"='PO To Wrong Vendor' OR "AHA"."HOLD_REASON"='PO has not been approved' OR

                            "AHA"."HOLD_REASON"='PO is complete' OR "AHA"."HOLD_REASON"='Total of Invoice Lines does not equal Invoice Amount')) AND

                            ("AH"."HOLD_REASON"='Amount billed exceeds amount ordered by more than the tolerance amount' OR "AH"."HOLD_REASON"='Amount

                            billed is greater than amount ordered * (1 + %ordered tolerance)' OR "AH"."HOLD_REASON"='Invoice price exceeds purchase order

                            price' OR "AH"."HOLD_REASON"='Invoice price exceeds purchase order price (total > $500)' OR "AH"."HOLD_REASON"='Quantity

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                            billed exceeds quantity ordered' OR "AH"."HOLD_REASON"='Quantity billed exceeds quantity ordered by tolerance amount' OR

                            "AH"."HOLD_REASON"='Total of Invoice Lines does not equal Invoice Amount' OR "AH"."HOLD_REASON"='Work Ticket Needed') OR

                            ("AH"."HOLD_REASON"='Invoice is not matched to any PO' OR "AH"."HOLD_REASON"='Total of Invoice Lines does not equal Invoice

                            Amount' OR "AH"."HOLD_REASON"='Total of invoice distributions does not equal invoice amount') AND  NOT EXISTS (SELECT 0 FROM

                            "APPS"."AP_HOLDS_ALL" "AH1" WHERE "AH1"."RELEASE_LOOKUP_CODE" IS NULL AND "AH1"."INVOICE_ID"=:B2 AND

                            ("AH1"."HOLD_REASON"='Approval Pending' OR "AH1"."HOLD_REASON"='Credit Needs Research' OR "AH1"."HOLD_REASON"='Distribution

                            account is invalid' OR "AH1"."HOLD_REASON"='Invoice amount exceeded limit' OR "AH1"."HOLD_REASON"='Line does not contain

                            enough data to produce distributions' OR "AH1"."HOLD_REASON"='Line references a skeleton Distribution Set' OR

                            "AH1"."HOLD_REASON"='Line references an inactive Distribution Set' OR "AH1"."HOLD_REASON"='PO has been over billed' OR

                            "AH1"."HOLD_REASON"='PO is Complete' OR "AH1"."HOLD_REASON"='Project Hold' OR "AH1"."HOLD_REASON"='Return invoice to vendor'

                            OR "AH1"."HOLD_REASON"='Subcontractor cannot be paid until the customer pays' OR "AH1"."HOLD_REASON"='Sum of invoice and

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                            exchange rate variances exceeds limit')) AND  NOT EXISTS (SELECT 0 FROM "APPS"."AP_HOLDS_ALL" "AH1" WHERE

                            "AH1"."RELEASE_LOOKUP_CODE" IS NULL AND "AH1"."INVOICE_ID"=:B3 AND ("AH1"."HOLD_REASON"='Credit Need RGA' OR

                            "AH1"."HOLD_REASON"='Credit Needs Research' OR "AH1"."HOLD_REASON"='Freight Needs Approval' OR "AH1"."HOLD_REASON"='Invoice

                            has invalid or missing PO number' OR "AH1"."HOLD_REASON"='Lines o)

                86 - access("PPA"."INVOICE_ID"(+)="AI"."INVOICE_ID")

                88 - access("COMM_INFO"."HOLD_ID"(+)="AH"."HOLD_ID")

                91 - access("PAV"."VENDOR_ID"="AI"."VENDOR_ID")

                94 - access("AH"."HOLD_ID"="AH"."HOLD_ID")

                95 - access("AC"."HOLD_ID"(+)="AH"."HOLD_ID")

              100 - filter(ROWNUM=1)

              103 - filter(ROWNUM=1)

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              106 - access("C"."SESSION_ID"=TO_NUMBER( (SELECT "V"('SESSION') FROM "SYS"."DUAL" "DUAL")) AND "C"."FLOW_ID"= (SELECT

                            "NV"('FLOW_ID') FROM "SYS"."DUAL" "DUAL") AND "C"."COLLECTION_NAME"='ALL_HOLDS' AND

                            "C"."SECURITY_GROUP_ID"="SGID"."SECURITY_GROUP_ID")

                     filter("C"."COLLECTION_NAME"='ALL_HOLDS' AND "C"."SECURITY_GROUP_ID"="SGID"."SECURITY_GROUP_ID" AND "C"."FLOW_ID"=

                            (SELECT "NV"('FLOW_ID') FROM "SYS"."DUAL" "DUAL"))

              109 - access("C"."ID"="M"."COLLECTION_ID")

              112 - access("AH"."RELEASE_LOOKUP_CODE" IS NULL)

                     filter("AH"."RELEASE_LOOKUP_CODE" IS NULL)

              114 - access("AH"."INVOICE_ID"="AI"."INVOICE_ID")

              117 - access("PAV"."PARTY_ID"="HP"."PARTY_ID")

              121 - filter(SYS_OP_BLOOM_FILTER(:BF0001,"HOLD_ID"))

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              124 - filter( NOT EXISTS (SELECT 0 FROM "APPS"."AP_INVOICE_LINES_ALL" "AIL" WHERE "AIL"."LINE_NUMBER"=:B1 AND

                            "AIL"."INVOICE_ID"=:B2 AND NVL("AIL"."DISCARDED_FLAG",'N')='Y'))

              126 - access("PPA"."PROJECT_ID"=NVL("POD"."PROJECT_ID","AID"."PROJECT_ID"))

              128 - access("POD"."PO_DISTRIBUTION_ID"(+)="AID"."PO_DISTRIBUTION_ID")

              130 - filter(NVL("AID"."REVERSAL_FLAG",'N')='N')

              131 - filter(NVL("AIL"."DISCARDED_FLAG",'N')='Y')

              132 - access("AIL"."INVOICE_ID"=:B1 AND "AIL"."LINE_NUMBER"=:B2)

              133 - filter("AHA"."HOLD_REASON"='Invoice has invalid or missing PO number' OR "AHA"."HOLD_REASON"='Invoice is not matched to

                            any PO' OR "AHA"."HOLD_REASON"='Lines on inv not on PO' OR "AHA"."HOLD_REASON"='Lot PO setup incorrectly' OR

                            "AHA"."HOLD_REASON"='PO Cancelled' OR "AHA"."HOLD_REASON"='PO To Wrong Vendor' OR "AHA"."HOLD_REASON"='PO has not been

                            approved' OR "AHA"."HOLD_REASON"='PO is complete' OR "AHA"."HOLD_REASON"='Total of Invoice Lines does not equal Invoice

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                            Amount')

              134 - access("AHA"."INVOICE_ID"=:B1 AND "AHA"."RELEASE_LOOKUP_CODE" IS NULL)

              135 - filter("AH1"."HOLD_REASON"='Approval Pending' OR "AH1"."HOLD_REASON"='Credit Needs Research' OR

                            "AH1"."HOLD_REASON"='Distribution account is invalid' OR "AH1"."HOLD_REASON"='Invoice amount exceeded limit' OR

                            "AH1"."HOLD_REASON"='Line does not contain enough data to produce distributions' OR "AH1"."HOLD_REASON"='Line references a

                            skeleton Distribution Set' OR "AH1"."HOLD_REASON"='Line references an inactive Distribution Set' OR "AH1"."HOLD_REASON"='PO

                            has been over billed' OR "AH1"."HOLD_REASON"='PO is Complete' OR "AH1"."HOLD_REASON"='Project Hold' OR

                            "AH1"."HOLD_REASON"='Return invoice to vendor' OR "AH1"."HOLD_REASON"='Subcontractor cannot be paid until the customer pays'

                            OR "AH1"."HOLD_REASON"='Sum of invoice and exchange rate variances exceeds limit')

              136 - access("AH1"."INVOICE_ID"=:B1 AND "AH1"."RELEASE_LOOKUP_CODE" IS NULL)

              137 - filter("AH1"."HOLD_REASON"='Credit Need RGA' OR "AH1"."HOLD_REASON"='Credit Needs Research' OR

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                            "AH1"."HOLD_REASON"='Freight Needs Approval' OR "AH1"."HOLD_REASON"='Invoice has invalid or missing PO number' OR

                            "AH1"."HOLD_REASON"='Lines on inv not on PO' OR "AH1"."HOLD_REASON"='Lot PO setup incorrectly' OR "AH1"."HOLD_REASON"='Open

                            RGA waiting on credit' OR "AH1"."HOLD_REASON"='PO Cancelled' OR "AH1"."HOLD_REASON"='PO To Wrong Vendor' OR

                            "AH1"."HOLD_REASON"='PO has been over billed' OR "AH1"."HOLD_REASON"='PO has not been approved' OR "AH1"."HOLD_REASON"='PO is

                            complete' OR "AH1"."HOLD_REASON"='RGA Pending Credit')

              138 - access("AH1"."INVOICE_ID"=:B1 AND "AH1"."RELEASE_LOOKUP_CODE" IS NULL)

              141 - filter("FND_PROFILE"."VALUE_SPECIFIC"('PA_SUPER_PROJECT',"USER_ID")='Y' OR

                            "FND_PROFILE"."VALUE_SPECIFIC"('PA_SUPER_PROJECT_VIEW',"USER_ID")='Y' OR  EXISTS (SELECT 0 FROM "PA"."PA_PROJECT_PARTIES"

                            "PA_PROJECT_PARTIES" WHERE "RESOURCE_SOURCE_ID"=DECODE(TO_CHAR(:B1),NULL,"PA_UTILS"."GET_PARTY_ID"(:B2),:B3) AND

                            "RESOURCE_TYPE_ID"=DECODE(TO_CHAR(:B4),NULL,112,101) AND "OBJECT_TYPE"='PA_PROJECTS' AND "OBJECT_ID"=:B5 AND "PROJECT_ID"=:B6)

                            OR  EXISTS (SELECT 0 FROM "APPLSYS"."FND_OBJECTS" "FO","APPLSYS"."FND_GRANTS" "FG" WHERE

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                            "FG"."GRANTEE_KEY"="PA_SECURITY_PVT"."GET_GRANTEE_KEY"() AND "FG"."GRANTEE_TYPE"='USER' AND "FG"."INSTANCE_TYPE"='INSTANCE'

                            AND TO_NUMBER("FG"."INSTANCE_PK1_VALUE")=:B7 AND NVL("FG"."END_DATE",SYSDATE@!+1)>=SYSDATE@! AND "FG"."START_DATE"<=SYSDATE@!

                            AND "FG"."OBJECT_ID"="FO"."OBJECT_ID" AND "FO"."OBJ_NAME"='ORGANIZATION'))

              142 - filter( NOT EXISTS (SELECT 0 FROM "APPS"."HR_ALL_ORGANIZATION_UNITS" "HAOU" WHERE

                            UPPER("HAOU"."ATTRIBUTE2")='OPERATIONS' AND UPPER("HAOU"."ATTRIBUTE1")=UPPER(:F_USER_NAME)))

              145 - access("USER_ID"="FND_GLOBAL"."USER_ID"())

              146 - filter("PPA"."TEMPLATE_FLAG"='N')

              147 - access("PPA"."PROJECT_ID"=:B1)

              148 - filter(UPPER("HAOU"."ATTRIBUTE2")='OPERATIONS' AND UPPER("HAOU"."ATTRIBUTE1")=UPPER(:F_USER_NAME))

              149 - filter("PROJECT_ID"=:B1)

              150 - access("OBJECT_ID"=:B1 AND "OBJECT_TYPE"='PA_PROJECTS' AND "RESOURCE_TYPE_ID"=DECODE(TO_CHAR(:B2),NULL,112,101) AND

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                            "RESOURCE_SOURCE_ID"=DECODE(TO_CHAR(:B3),NULL,"PA_UTILS"."GET_PARTY_ID"(:B4),:B5))

              153 - access("FO"."OBJ_NAME"='ORGANIZATION')

              154 - filter("FG"."INSTANCE_TYPE"='INSTANCE' AND TO_NUMBER("FG"."INSTANCE_PK1_VALUE")=:B1 AND

                            NVL("FG"."END_DATE",SYSDATE@!+1)>=SYSDATE@! AND "FG"."START_DATE"<=SYSDATE@! AND "FG"."OBJECT_ID"="FO"."OBJECT_ID")

              155 - access("FG"."GRANTEE_TYPE"='USER' AND "FG"."GRANTEE_KEY"="PA_SECURITY_PVT"."GET_GRANTEE_KEY"())

              156 - access(UPPER("HAOU"."NAME")=UPPER("XPD"."PROJECT_STATE"))

                     filter(UPPER("XPD"."PROJECT_MANAGER")=UPPER(:F_USER_NAME) OR UPPER("HAOU"."ATTRIBUTE1")=UPPER(:F_USER_NAME))

              157 - access("BUDGET"."PROJECT_ID"(+)="XPD"."PROJECT_ID")

              158 - filter("XPD"."PROJECT_ID"=:B1)

              160 - access("SUB_QUERY"."PROJECT_ID"=:B1 AND "SUB_QUERY"."END_DATE"= (SELECT "END_DATE" FROM "XXDW"."XXDW_PERIODS_DIM"

                            "XXDW_PERIODS_DIM" WHERE "CURRENT_PA_PERIOD_FLAG"='Y'))

               

               

              PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                          

              ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

              161 - filter("CURRENT_PA_PERIOD_FLAG"='Y')

              162 - filter(UPPER("HAOU"."ATTRIBUTE2")='OPERATIONS')

               

              Note

              -----

                 - 'PLAN_TABLE' is old version

               

               

              Statistics

              -----------------------------------------------------------

                             1  CPU used by this session

                             4  CPU used when call started

                            13  DB time

                             2  Requests to/from client

                             2  non-idle wait count

                             1  opened cursors cumulative

                             1  opened cursors current

                             1  pinned cursors current

                             2  user calls

              Elapsed: 00:00:08.944

               

              5. The EXPLAIN PLAN output

               

               

              --------------------------------------------------------------------------------------------------

              | Id  | Operation                                               | Name                           |

              --------------------------------------------------------------------------------------------------

              |   0 | SELECT STATEMENT                                        |                                |

              |   1 |  COUNT STOPKEY                                          |                                |

              |   2 |   NESTED LOOPS                                          |                                |

              |   3 |    NESTED LOOPS                                         |                                |

              |   4 |     TABLE ACCESS BY INDEX ROWID BATCHED                 | AP_INVOICE_DISTRIBUTIONS_ALL   |

              |   5 |      INDEX RANGE SCAN                                   | AP_INVOICE_DISTRIBUTIONS_N27   |

              |   6 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |

              |   7 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |

              |   8 |  COUNT STOPKEY                                          |                                |

              |   9 |   NESTED LOOPS                                          |                                |

              |  10 |    NESTED LOOPS                                         |                                |

              |  11 |     NESTED LOOPS                                        |                                |

              |  12 |      TABLE ACCESS BY INDEX ROWID BATCHED                | AP_INVOICE_DISTRIBUTIONS_ALL   |

              |  13 |       INDEX RANGE SCAN                                  | AP_INVOICE_DISTRIBUTIONS_N27   |

              |  14 |      TABLE ACCESS BY INDEX ROWID                        | PO_DISTRIBUTIONS_ALL           |

              |  15 |       INDEX UNIQUE SCAN                                 | PO_DISTRIBUTIONS_U1            |

              |  16 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |

              |  17 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |

              |  18 |  COUNT STOPKEY                                          |                                |

              |  19 |   NESTED LOOPS                                          |                                |

              |  20 |    NESTED LOOPS                                         |                                |

              |  21 |     TABLE ACCESS BY INDEX ROWID BATCHED                 | AP_INVOICE_DISTRIBUTIONS_ALL   |

              |  22 |      INDEX RANGE SCAN                                   | AP_INVOICE_DISTRIBUTIONS_N27   |

              |  23 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |

              |  24 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |

              |  25 |  COUNT STOPKEY                                          |                                |

              |  26 |   NESTED LOOPS                                          |                                |

              |  27 |    NESTED LOOPS                                         |                                |

              |  28 |     NESTED LOOPS                                        |                                |

              |  29 |      TABLE ACCESS BY INDEX ROWID BATCHED                | AP_INVOICE_DISTRIBUTIONS_ALL   |

              |  30 |       INDEX RANGE SCAN                                  | AP_INVOICE_DISTRIBUTIONS_N27   |

              |  31 |      TABLE ACCESS BY INDEX ROWID                        | PO_DISTRIBUTIONS_ALL           |

              |  32 |       INDEX UNIQUE SCAN                                 | PO_DISTRIBUTIONS_U1            |

              |  33 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |

              |  34 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |

              |  35 |  WINDOW SORT                                            |                                |

              |  36 |   COUNT STOPKEY                                         |                                |

              |  37 |    NESTED LOOPS                                         |                                |

              |  38 |     NESTED LOOPS                                        |                                |

              |  39 |      NESTED LOOPS                                       |                                |

              |  40 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_ROLE_TYPES_TL       |

              |  41 |        INDEX RANGE SCAN                                 | PA_PROJECT_ROLE_TYPES_TL_U2    |

              |  42 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |

              |  43 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_N1          |

              |  44 |      INDEX RANGE SCAN                                   | PER_PEOPLE_F_PK                |

              |  45 |     TABLE ACCESS BY INDEX ROWID                         | PER_ALL_PEOPLE_F               |

              |  46 |  WINDOW SORT                                            |                                |

              |  47 |   COUNT STOPKEY                                         |                                |

              |  48 |    NESTED LOOPS                                         |                                |

              |  49 |     NESTED LOOPS                                        |                                |

              |  50 |      NESTED LOOPS                                       |                                |

              |  51 |       TABLE ACCESS FULL                                 | PA_PROJECT_ROLE_TYPES_TL       |

              |  52 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |

              |  53 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_N1          |

              |  54 |      INDEX RANGE SCAN                                   | PER_PEOPLE_F_PK                |

              |  55 |     TABLE ACCESS BY INDEX ROWID                         | PER_ALL_PEOPLE_F               |

              |  56 |  WINDOW SORT                                            |                                |

              |  57 |   COUNT STOPKEY                                         |                                |

              |  58 |    NESTED LOOPS                                         |                                |

              |  59 |     NESTED LOOPS                                        |                                |

              |  60 |      NESTED LOOPS                                       |                                |

              |  61 |       TABLE ACCESS FULL                                 | PA_PROJECT_ROLE_TYPES_TL       |

              |  62 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |

              |  63 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_N1          |

              |  64 |      INDEX RANGE SCAN                                   | PER_PEOPLE_F_PK                |

              |  65 |     TABLE ACCESS BY INDEX ROWID                         | PER_ALL_PEOPLE_F               |

              |  66 |  SORT AGGREGATE                                         |                                |

              |  67 |   TABLE ACCESS BY INDEX ROWID BATCHED                   | AP_PAYMENT_SCHEDULES_ALL       |

              |  68 |    INDEX RANGE SCAN                                     | AP_PAYMENT_SCHEDULES_U1        |

              |  69 |  SORT AGGREGATE                                         |                                |

              |  70 |   TABLE ACCESS BY INDEX ROWID BATCHED                   | AP_PAYMENT_SCHEDULES_ALL       |

              |  71 |    INDEX RANGE SCAN                                     | AP_PAYMENT_SCHEDULES_U1        |

              |  72 |  NESTED LOOPS                                           |                                |

              |  73 |   TABLE ACCESS BY INDEX ROWID                           | PO_LINE_LOCATIONS_ALL          |

              |  74 |    INDEX UNIQUE SCAN                                    | PO_LINE_LOCATIONS_U1           |

              |  75 |   TABLE ACCESS BY INDEX ROWID                           | PO_LINES_ALL                   |

              |  76 |    INDEX UNIQUE SCAN                                    | PO_LINES_U1                    |

              |  77 |  NESTED LOOPS                                           |                                |

              |  78 |   TABLE ACCESS BY INDEX ROWID                           | PO_LINE_LOCATIONS_ALL          |

              |  79 |    INDEX UNIQUE SCAN                                    | PO_LINE_LOCATIONS_U1           |

              |  80 |   TABLE ACCESS BY INDEX ROWID                           | XXPD_BOM_LINES                 |

              |  81 |    INDEX UNIQUE SCAN                                    | SYS_C00262182                  |

              |  82 |  TABLE ACCESS BY INDEX ROWID BATCHED                    | PER_ALL_PEOPLE_F               |

              |  83 |   INDEX RANGE SCAN                                      | PER_PEOPLE_F_PK                |

              |  84 |  SORT UNIQUE                                            |                                |

              |  85 |   FILTER                                                |                                |

              |  86 |    HASH JOIN OUTER                                      |                                |

              |  87 |     JOIN FILTER CREATE                                  | :BF0000                        |

              |  88 |      HASH JOIN OUTER                                    |                                |

              |  89 |       JOIN FILTER CREATE                                | :BF0001                        |

              |  90 |        NESTED LOOPS                                     |                                |

              |  91 |         HASH JOIN                                       |                                |

              |  92 |          NESTED LOOPS                                   |                                |

              |  93 |           NESTED LOOPS                                  |                                |

              |  94 |            HASH JOIN                                    |                                |

              |  95 |             HASH JOIN RIGHT OUTER                       |                                |

              |  96 |              VIEW                                       |                                |

              |  97 |               NESTED LOOPS                              |                                |

              |  98 |                NESTED LOOPS                             |                                |

              |  99 |                 NESTED LOOPS                            |                                |

              | 100 |                  COUNT STOPKEY                          |                                |

              | 101 |                   FAST DUAL                             |                                |

              | 102 |                  VIEW                                   | WWV_FLOW_CURRENT_SGID          |

              | 103 |                   COUNT STOPKEY                         |                                |

              | 104 |                    COLLECTION ITERATOR CONSTRUCTOR FETCH|                                |

              | 105 |                  TABLE ACCESS BY INDEX ROWID BATCHED    | WWV_FLOW_COLLECTIONS$          |

              | 106 |                   INDEX RANGE SCAN                      | WWV_FLOW_COLLECTIONS_UK        |

              | 107 |                    FAST DUAL                            |                                |

              | 108 |                    FAST DUAL                            |                                |

              | 109 |                 INDEX RANGE SCAN                        | WWV_FLOW_COLLECTION_MEMBERS_PK |

              | 110 |                TABLE ACCESS BY INDEX ROWID              | WWV_FLOW_COLLECTION_MEMBERS$   |

              | 111 |              TABLE ACCESS BY INDEX ROWID BATCHED        | AP_HOLDS_ALL                   |

              | 112 |               INDEX SKIP SCAN                           | AP_HOLDS_N1                    |

              | 113 |             TABLE ACCESS FULL                           | AP_HOLDS_ALL                   |

              | 114 |            INDEX UNIQUE SCAN                            | AP_INVOICES_U1                 |

              | 115 |           TABLE ACCESS BY INDEX ROWID                   | AP_INVOICES_ALL                |

              | 116 |          TABLE ACCESS FULL                              | AP_SUPPLIERS                   |

              | 117 |         INDEX UNIQUE SCAN                               | HZ_PARTIES_U1                  |

              | 118 |       VIEW                                              |                                |

              | 119 |        HASH GROUP BY                                    |                                |

              | 120 |         JOIN FILTER USE                                 | :BF0001                        |

              | 121 |          TABLE ACCESS FULL                              | XXEXT_AP_HOLDS_COMMENTS        |

              | 122 |     VIEW                                                |                                |

              | 123 |      HASH UNIQUE                                        |                                |

              | 124 |       FILTER                                            |                                |

              | 125 |        JOIN FILTER USE                                  | :BF0000                        |

              | 126 |         HASH JOIN                                       |                                |

              | 127 |          TABLE ACCESS FULL                              | PA_PROJECTS_ALL                |

              | 128 |          HASH JOIN RIGHT OUTER                          |                                |

              | 129 |           INDEX FULL SCAN                               | PO_DISTRIBUTIONS_N15           |

              | 130 |           TABLE ACCESS FULL                             | AP_INVOICE_DISTRIBUTIONS_ALL   |

              | 131 |        TABLE ACCESS BY INDEX ROWID                      | AP_INVOICE_LINES_ALL           |

              | 132 |         INDEX UNIQUE SCAN                               | AP_INVOICE_LINES_U1            |

              | 133 |    TABLE ACCESS BY INDEX ROWID BATCHED                  | AP_HOLDS_ALL                   |

              | 134 |     INDEX RANGE SCAN                                    | AP_HOLDS_N1                    |

              | 135 |    TABLE ACCESS BY INDEX ROWID BATCHED                  | AP_HOLDS_ALL                   |

              | 136 |     INDEX RANGE SCAN                                    | AP_HOLDS_N1                    |

              | 137 |    TABLE ACCESS BY INDEX ROWID BATCHED                  | AP_HOLDS_ALL                   |

              | 138 |     INDEX RANGE SCAN                                    | AP_HOLDS_N1                    |

              | 139 |    SORT UNIQUE                                          |                                |

              | 140 |     UNION-ALL                                           |                                |

              | 141 |      FILTER                                             |                                |

              | 142 |       FILTER                                            |                                |

              | 143 |        NESTED LOOPS                                     |                                |

              | 144 |         TABLE ACCESS BY INDEX ROWID                     | FND_USER                       |

              | 145 |          INDEX UNIQUE SCAN                              | FND_USER_U1                    |

              | 146 |         TABLE ACCESS BY INDEX ROWID BATCHED             | PA_PROJECTS_ALL                |

              | 147 |          INDEX RANGE SCAN                               | PA_PROJECTS_U1                 |

              | 148 |        TABLE ACCESS FULL                                | HR_ALL_ORGANIZATION_UNITS      |

              | 149 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |

              | 150 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_U2          |

              | 151 |       NESTED LOOPS                                      |                                |

              | 152 |        TABLE ACCESS BY INDEX ROWID                      | FND_OBJECTS                    |

              | 153 |         INDEX UNIQUE SCAN                               | FND_OBJECTS_U2                 |

              | 154 |        TABLE ACCESS BY INDEX ROWID BATCHED              | FND_GRANTS                     |

              | 155 |         INDEX RANGE SCAN                                | FND_GRANTS_N1                  |

              | 156 |      HASH JOIN                                          |                                |

              | 157 |       HASH JOIN OUTER                                   |                                |

              | 158 |        TABLE ACCESS FULL                                | XXDW_PROJECTS_DTL_T            |

              | 159 |        VIEW                                             |                                |

              | 160 |         INDEX RANGE SCAN                                | XXDW_PROJECT_SUMMARY_N1        |

              | 161 |          TABLE ACCESS FULL                              | XXDW_PERIODS_DIM               |

              | 162 |       TABLE ACCESS FULL                                 | HR_ALL_ORGANIZATION_UNITS      |

              --------------------------------------------------------------------------------------------------

               

              6. The TKPROF output snippet that corresponds to your statement

              7. If you're on 10g or later, the DBMS_XPLAN.DISPLAY_CURSOR output

               

              SQL_ID  98qunpwpdrgga, child number 3

              -------------------------------------

              WITH all_holds AS   (SELECT NVL(     (SELECT dom     FROM

              apps.xxdw_tasks_dim xtd,       apps.ap_invoice_distributions_all aid   

              WHERE xtd.project_id = aid.project_id     AND aid.invoice_id   =

              ai.invoice_id     AND ROWNUM           < 2     AND

              nvl(AID.REVERSAL_FLAG, 'N') = 'N' -- DR     ),     (SELECT dom     FROM

              apps.xxdw_tasks_dim xtd,       apps.ap_invoice_distributions_all aid,  

                  apps.po_distributions_all pod     WHERE xtd.project_id       =

              pod.project_id     AND pod.po_distribution_id = aid.po_distribution_id 

                 AND aid.invoice_id         = ai.invoice_id     AND ROWNUM           

                   < 2     AND nvl(AID.REVERSAL_FLAG, 'N') = 'N'  -- DR     )) dom,  

                NVL(     (SELECT project_manager     FROM apps.xxdw_tasks_dim xtd,   

                 apps.ap_invoice_distributions_all aid     WHERE xtd.project_id =

              aid.project_id     AND aid.invoice_id   = ai.invoice_id     AND ROWNUM 

                       < 2     AND nvl(AID.REVERSAL_FLAG, 'N') = 'N' -- DR     ),    

              (SELECT project_manager     FROM apps.xxdw

               

              Plan hash value: 3767530311

               

              --------------------------------------------------------------------------------------------------------------------------------------------------

              | Id  | Operation                                               | Name                           | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |

              --------------------------------------------------------------------------------------------------------------------------------------------------

              |   0 | SELECT STATEMENT                                        |                                |       |       |       |   308M(100)|          |

              |*  1 |  COUNT STOPKEY                                          |                                |       |       |       |            |          |

              |   2 |   NESTED LOOPS                                          |                                |  1684 | 65676 |       |   352   (0)| 00:00:01 |

              |   3 |    NESTED LOOPS                                         |                                |  1740 | 65676 |       |   352   (0)| 00:00:01 |

              |*  4 |     TABLE ACCESS BY INDEX ROWID BATCHED                 | AP_INVOICE_DISTRIBUTIONS_ALL   |    15 |   195 |       |     7   (0)| 00:00:01 |

              |*  5 |      INDEX RANGE SCAN                                   | AP_INVOICE_DISTRIBUTIONS_N27   |    24 |       |       |     3   (0)| 00:00:01 |

              |*  6 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |   116 |       |       |     2   (0)| 00:00:01 |

              |   7 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |   113 |  2938 |       |    23   (0)| 00:00:01 |

              |*  8 |   COUNT STOPKEY                                         |                                |       |       |       |            |          |

              |   9 |    NESTED LOOPS                                         |                                |  1134 | 56700 |       |   257   (0)| 00:00:01 |

              |  10 |     NESTED LOOPS                                        |                                |  1160 | 56700 |       |   257   (0)| 00:00:01 |

              |  11 |      NESTED LOOPS                                       |                                |    10 |   240 |       |    27   (0)| 00:00:01 |

              |* 12 |       TABLE ACCESS BY INDEX ROWID BATCHED               | AP_INVOICE_DISTRIBUTIONS_ALL   |    10 |   130 |       |     7   (0)| 00:00:01 |

              |* 13 |        INDEX RANGE SCAN                                 | AP_INVOICE_DISTRIBUTIONS_N27   |    24 |       |       |     3   (0)| 00:00:01 |

              |  14 |       TABLE ACCESS BY INDEX ROWID                       | PO_DISTRIBUTIONS_ALL           |     1 |    11 |       |     2   (0)| 00:00:01 |

              |* 15 |        INDEX UNIQUE SCAN                                | PO_DISTRIBUTIONS_U1            |     1 |       |       |     1   (0)| 00:00:01 |

              |* 16 |      INDEX RANGE SCAN                                   | XXDW_TASKS_DIM_N2              |   116 |       |       |     2   (0)| 00:00:01 |

              |  17 |     TABLE ACCESS BY INDEX ROWID                         | XXDW_TASKS_DIM_T               |   115 |  2990 |       |    23   (0)| 00:00:01 |

              |* 18 |  COUNT STOPKEY                                          |                                |       |       |       |            |          |

              |  19 |   NESTED LOOPS                                          |                                |  1684 | 62308 |       |   352   (0)| 00:00:01 |

              |  20 |    NESTED LOOPS                                         |                                |  1740 | 62308 |       |   352   (0)| 00:00:01 |

              |* 21 |     TABLE ACCESS BY INDEX ROWID BATCHED                 | AP_INVOICE_DISTRIBUTIONS_ALL   |    15 |   195 |       |     7   (0)| 00:00:01 |

              |* 22 |      INDEX RANGE SCAN                                   | AP_INVOICE_DISTRIBUTIONS_N27   |    24 |       |       |     3   (0)| 00:00:01 |

              |* 23 |     INDEX RANGE SCAN                                    | XXDW_TASKS_DIM_N2              |   116 |       |       |     2   (0)| 00:00:01 |

              |  24 |    TABLE ACCESS BY INDEX ROWID                          | XXDW_TASKS_DIM_T               |   113 |  2712 |       |    23   (0)| 00:00:01 |

              |* 25 |   COUNT STOPKEY                                         |                                |       |       |       |            |          |

              |  26 |    NESTED LOOPS                                         |                                |  1134 | 54432 |       |   257   (0)| 00:00:01 |

              |  27 |     NESTED LOOPS                                        |                                |  1160 | 54432 |       |   257   (0)| 00:00:01 |

              |  28 |      NESTED LOOPS                                       |                                |    10 |   240 |       |    27   (0)| 00:00:01 |

              |* 29 |       TABLE ACCESS BY INDEX ROWID BATCHED               | AP_INVOICE_DISTRIBUTIONS_ALL   |    10 |   130 |       |     7   (0)| 00:00:01 |

              |* 30 |        INDEX RANGE SCAN                                 | AP_INVOICE_DISTRIBUTIONS_N27   |    24 |       |       |     3   (0)| 00:00:01 |

              |  31 |       TABLE ACCESS BY INDEX ROWID                       | PO_DISTRIBUTIONS_ALL           |     1 |    11 |       |     2   (0)| 00:00:01 |

              |* 32 |        INDEX UNIQUE SCAN                                | PO_DISTRIBUTIONS_U1            |     1 |       |       |     1   (0)| 00:00:01 |

              |* 33 |      INDEX RANGE SCAN                                   | XXDW_TASKS_DIM_N2              |   116 |       |       |     2   (0)| 00:00:01 |

              |  34 |     TABLE ACCESS BY INDEX ROWID                         | XXDW_TASKS_DIM_T               |   115 |  2760 |       |    23   (0)| 00:00:01 |

              |  35 |  WINDOW SORT                                            |                                |     1 |    87 |       |    10  (10)| 00:00:01 |

              |* 36 |   COUNT STOPKEY                                         |                                |       |       |       |            |          |

              |  37 |    NESTED LOOPS                                         |                                |     1 |    87 |       |     9   (0)| 00:00:01 |

              |  38 |     NESTED LOOPS                                        |                                |     2 |    87 |       |     9   (0)| 00:00:01 |

              |  39 |      NESTED LOOPS                                       |                                |     1 |    50 |       |     5   (0)| 00:00:01 |

              |  40 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_ROLE_TYPES_TL       |     1 |    27 |       |     2   (0)| 00:00:01 |

              |* 41 |        INDEX RANGE SCAN                                 | PA_PROJECT_ROLE_TYPES_TL_U2    |     1 |       |       |     1   (0)| 00:00:01 |

              |* 42 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |     1 |    23 |       |     3   (0)| 00:00:01 |

              |* 43 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_N1          |     4 |       |       |     1   (0)| 00:00:01 |

              |* 44 |      INDEX RANGE SCAN                                   | PER_PEOPLE_F_PK                |     2 |       |       |     1   (0)| 00:00:01 |

              |  45 |     TABLE ACCESS BY INDEX ROWID                         | PER_ALL_PEOPLE_F               |     1 |    37 |       |     4   (0)| 00:00:01 |

              |  46 |  WINDOW SORT                                            |                                |     1 |    87 |       |    26   (4)| 00:00:01 |

              |* 47 |   COUNT STOPKEY                                         |                                |       |       |       |            |          |

              |  48 |    NESTED LOOPS                                         |                                |     4 |   348 |       |    25   (0)| 00:00:01 |

              |  49 |     NESTED LOOPS                                        |                                |     6 |   348 |       |    25   (0)| 00:00:01 |

              |  50 |      NESTED LOOPS                                       |                                |     3 |   150 |       |    13   (0)| 00:00:01 |

              |* 51 |       TABLE ACCESS FULL                                 | PA_PROJECT_ROLE_TYPES_TL       |     3 |    81 |       |     6   (0)| 00:00:01 |

              |* 52 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |     1 |    23 |       |     3   (0)| 00:00:01 |

              |* 53 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_N1          |     4 |       |       |     1   (0)| 00:00:01 |

              |* 54 |      INDEX RANGE SCAN                                   | PER_PEOPLE_F_PK                |     2 |       |       |     1   (0)| 00:00:01 |

              |  55 |     TABLE ACCESS BY INDEX ROWID                         | PER_ALL_PEOPLE_F               |     1 |    37 |       |     4   (0)| 00:00:01 |

              |  56 |  WINDOW SORT                                            |                                |     1 |    87 |       |    26   (4)| 00:00:01 |

              |* 57 |   COUNT STOPKEY                                         |                                |       |       |       |            |          |

              |  58 |    NESTED LOOPS                                         |                                |     4 |   348 |       |    25   (0)| 00:00:01 |

              |  59 |     NESTED LOOPS                                        |                                |     6 |   348 |       |    25   (0)| 00:00:01 |

              |  60 |      NESTED LOOPS                                       |                                |     3 |   150 |       |    13   (0)| 00:00:01 |

              |* 61 |       TABLE ACCESS FULL                                 | PA_PROJECT_ROLE_TYPES_TL       |     3 |    81 |       |     6   (0)| 00:00:01 |

              |* 62 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |     1 |    23 |       |     3   (0)| 00:00:01 |

              |* 63 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_N1          |     4 |       |       |     1   (0)| 00:00:01 |

              |* 64 |      INDEX RANGE SCAN                                   | PER_PEOPLE_F_PK                |     2 |       |       |     1   (0)| 00:00:01 |

              |  65 |     TABLE ACCESS BY INDEX ROWID                         | PER_ALL_PEOPLE_F               |     1 |    37 |       |     4   (0)| 00:00:01 |

              |  66 |  SORT AGGREGATE                                         |                                |     1 |    18 |       |            |          |

              |  67 |   TABLE ACCESS BY INDEX ROWID BATCHED                   | AP_PAYMENT_SCHEDULES_ALL       |     1 |    18 |       |     4   (0)| 00:00:01 |

              |* 68 |    INDEX RANGE SCAN                                     | AP_PAYMENT_SCHEDULES_U1        |     1 |       |       |     3   (0)| 00:00:01 |

              |  69 |  SORT AGGREGATE                                         |                                |     1 |    18 |       |            |          |

              |  70 |   TABLE ACCESS BY INDEX ROWID BATCHED                   | AP_PAYMENT_SCHEDULES_ALL       |     1 |    18 |       |     4   (0)| 00:00:01 |

              |* 71 |    INDEX RANGE SCAN                                     | AP_PAYMENT_SCHEDULES_U1        |     1 |       |       |     3   (0)| 00:00:01 |

              |  72 |  NESTED LOOPS                                           |                                |     1 |    22 |       |     5   (0)| 00:00:01 |

              |  73 |   TABLE ACCESS BY INDEX ROWID                           | PO_LINE_LOCATIONS_ALL          |     1 |    12 |       |     3   (0)| 00:00:01 |

              |* 74 |    INDEX UNIQUE SCAN                                    | PO_LINE_LOCATIONS_U1           |     1 |       |       |     2   (0)| 00:00:01 |

              |  75 |   TABLE ACCESS BY INDEX ROWID                           | PO_LINES_ALL                   |     1 |    10 |       |     2   (0)| 00:00:01 |

              |* 76 |    INDEX UNIQUE SCAN                                    | PO_LINES_U1                    |     1 |       |       |     1   (0)| 00:00:01 |

              |  77 |  NESTED LOOPS                                           |                                |     1 |    22 |       |     5   (0)| 00:00:01 |

              |  78 |   TABLE ACCESS BY INDEX ROWID                           | PO_LINE_LOCATIONS_ALL          |     1 |    13 |       |     3   (0)| 00:00:01 |

              |* 79 |    INDEX UNIQUE SCAN                                    | PO_LINE_LOCATIONS_U1           |     1 |       |       |     2   (0)| 00:00:01 |

              |  80 |   TABLE ACCESS BY INDEX ROWID                           | XXPD_BOM_LINES                 |     1 |     9 |       |     2   (0)| 00:00:01 |

              |* 81 |    INDEX UNIQUE SCAN                                    | SYS_C00262182                  |     1 |       |       |     1   (0)| 00:00:01 |

              |  82 |  TABLE ACCESS BY INDEX ROWID BATCHED                    | PER_ALL_PEOPLE_F               |     2 |    74 |       |     4   (0)| 00:00:01 |

              |* 83 |   INDEX RANGE SCAN                                      | PER_PEOPLE_F_PK                |     2 |       |       |     1   (0)| 00:00:01 |

              |  84 |  SORT UNIQUE                                            |                                |     1 |   728 |       |   308M  (5)| 05:13:45 |

              |* 85 |   FILTER                                                |                                |       |       |       |            |          |

              |* 86 |    HASH JOIN OUTER                                      |                                |  2407 |  1711K|       |   308M  (5)| 05:13:35 |

              |  87 |     JOIN FILTER CREATE                                  | :BF0000                        |   408 |   121K|       |  9672   (3)| 00:00:01 |

              |* 88 |      HASH JOIN OUTER                                    |                                |   408 |   121K|       |  9672   (3)| 00:00:01 |

              |  89 |       JOIN FILTER CREATE                                | :BF0001                        |   273 | 76167 |       |  9426   (3)| 00:00:01 |

              |  90 |        NESTED LOOPS                                     |                                |   273 | 76167 |       |  9426   (3)| 00:00:01 |

              |* 91 |         HASH JOIN                                       |                                |   273 | 74802 |       |  9426   (3)| 00:00:01 |

              |  92 |          NESTED LOOPS                                   |                                |   273 | 61698 |       |  9356   (3)| 00:00:01 |

              |  93 |           NESTED LOOPS                                  |                                |   273 | 61698 |       |  9356   (3)| 00:00:01 |

              |* 94 |            HASH JOIN                                    |                                |   273 | 43680 |       |  8809   (3)| 00:00:01 |

              |* 95 |             HASH JOIN RIGHT OUTER                       |                                |   273 | 26754 |       |  3662   (1)| 00:00:01 |

              |  96 |              VIEW                                       |                                |     1 |    11 |       |    48   (0)| 00:00:01 |

              |  97 |               NESTED LOOPS                              |                                |     1 |    79 |       |    46   (0)| 00:00:01 |

              |  98 |                NESTED LOOPS                             |                                |   252 |    79 |       |    46   (0)| 00:00:01 |

              |  99 |                 NESTED LOOPS                            |                                |     1 |    59 |       |    33   (0)| 00:00:01 |

              |*100 |                  COUNT STOPKEY                          |                                |       |       |       |            |          |

              | 101 |                   FAST DUAL                             |                                |     1 |       |       |     2   (0)| 00:00:01 |

              | 102 |                  VIEW                                   | WWV_FLOW_CURRENT_SGID          |     1 |    13 |       |    31   (0)| 00:00:01 |

              |*103 |                   COUNT STOPKEY                         |                                |       |       |       |            |          |

              | 104 |                    COLLECTION ITERATOR CONSTRUCTOR FETCH|                                |     1 |       |       |    29   (0)| 00:00:01 |

              | 105 |                  TABLE ACCESS BY INDEX ROWID BATCHED    | WWV_FLOW_COLLECTIONS$          |     1 |    46 |       |     2   (0)| 00:00:01 |

              |*106 |                   INDEX RANGE SCAN                      | WWV_FLOW_COLLECTIONS_UK        |     1 |       |       |     1   (0)| 00:00:01 |

              | 107 |                    FAST DUAL                            |                                |     1 |       |       |     2   (0)| 00:00:01 |

              | 108 |                    FAST DUAL                            |                                |     1 |       |       |     2   (0)| 00:00:01 |

              |*109 |                 INDEX RANGE SCAN                        | WWV_FLOW_COLLECTION_MEMBERS_PK |   252 |       |       |     4   (0)| 00:00:01 |

              | 110 |                TABLE ACCESS BY INDEX ROWID              | WWV_FLOW_COLLECTION_MEMBERS$   |   252 |  5040 |       |    13   (0)| 00:00:01 |

              | 111 |              TABLE ACCESS BY INDEX ROWID BATCHED        | AP_HOLDS_ALL                   |   273 | 23751 |       |  3613   (1)| 00:00:01 |

              |*112 |               INDEX SKIP SCAN                           | AP_HOLDS_N1                    |   273 |       |       |  3578   (1)| 00:00:01 |

              | 113 |             TABLE ACCESS FULL                           | AP_HOLDS_ALL                   |   787K|    46M|       |  5138   (5)| 00:00:01 |

              |*114 |            INDEX UNIQUE SCAN                            | AP_INVOICES_U1                 |     1 |       |       |     1   (0)| 00:00:01 |

              | 115 |           TABLE ACCESS BY INDEX ROWID                   | AP_INVOICES_ALL                |     1 |    66 |       |     2   (0)| 00:00:01 |

              | 116 |          TABLE ACCESS FULL                              | AP_SUPPLIERS                   |  4947 |   231K|       |    70   (3)| 00:00:01 |

              |*117 |         INDEX UNIQUE SCAN                               | HZ_PARTIES_U1                  |     1 |     5 |       |     0   (0)|          |

              | 118 |       VIEW                                              |                                | 26747 |   705K|       |   246   (4)| 00:00:01 |

              | 119 |        HASH GROUP BY                                    |                                | 26747 |   339K|       |   246   (4)| 00:00:01 |

              | 120 |         JOIN FILTER USE                                 | :BF0001                        | 44500 |   564K|       |   241   (2)| 00:00:01 |

              |*121 |          TABLE ACCESS FULL                              | XXEXT_AP_HOLDS_COMMENTS        | 44500 |   564K|       |   241   (2)| 00:00:01 |

              | 122 |     VIEW                                                |                                |  4709K|  1895M|       |   308M  (5)| 05:13:35 |

              | 123 |      HASH UNIQUE                                        |                                |  4709K|   336M|   399M|   308M  (5)| 05:13:35 |

              |*124 |       FILTER                                            |                                |       |       |       |            |          |

              | 125 |        JOIN FILTER USE                                  | :BF0000                        |  4709K|   336M|       |   121K  (4)| 00:00:08 |

              |*126 |         HASH JOIN                                       |                                |  4709K|   336M|       |   121K  (4)| 00:00:08 |

              | 127 |          TABLE ACCESS FULL                              | PA_PROJECTS_ALL                |  3545 |   145K|       |    96   (3)| 00:00:01 |

              |*128 |          HASH JOIN RIGHT OUTER                          |                                |  4709K|   148M|    38M|   121K  (4)| 00:00:08 |

              | 129 |           INDEX FULL SCAN                               | PO_DISTRIBUTIONS_N15           |  1776K|    18M|       | 12223   (1)| 00:00:01 |

              |*130 |           TABLE ACCESS FULL                             | AP_INVOICE_DISTRIBUTIONS_ALL   |  3738K|    78M|       | 99593   (4)| 00:00:07 |

              |*131 |        TABLE ACCESS BY INDEX ROWID                      | AP_INVOICE_LINES_ALL           |     1 |    12 |       |     3   (0)| 00:00:01 |

              |*132 |         INDEX UNIQUE SCAN                               | AP_INVOICE_LINES_U1            |     1 |       |       |     2   (0)| 00:00:01 |

              |*133 |    TABLE ACCESS BY INDEX ROWID BATCHED                  | AP_HOLDS_ALL                   |     1 |    67 |       |     4   (0)| 00:00:01 |

              |*134 |     INDEX RANGE SCAN                                    | AP_HOLDS_N1                    |     1 |       |       |     3   (0)| 00:00:01 |

              |*135 |    TABLE ACCESS BY INDEX ROWID BATCHED                  | AP_HOLDS_ALL                   |     1 |    67 |       |     4   (0)| 00:00:01 |

              |*136 |     INDEX RANGE SCAN                                    | AP_HOLDS_N1                    |     1 |       |       |     3   (0)| 00:00:01 |

              |*137 |    TABLE ACCESS BY INDEX ROWID BATCHED                  | AP_HOLDS_ALL                   |     1 |    67 |       |     4   (0)| 00:00:01 |

              |*138 |     INDEX RANGE SCAN                                    | AP_HOLDS_N1                    |     1 |       |       |     3   (0)| 00:00:01 |

              | 139 |    SORT UNIQUE                                          |                                |     2 |   158 |       |   124   (3)| 00:00:01 |

              | 140 |     UNION-ALL                                           |                                |       |       |       |            |          |

              |*141 |      FILTER                                             |                                |       |       |       |            |          |

              |*142 |       FILTER                                            |                                |       |       |       |            |          |

              | 143 |        NESTED LOOPS                                     |                                |     1 |    19 |       |     4   (0)| 00:00:01 |

              | 144 |         TABLE ACCESS BY INDEX ROWID                     | FND_USER                       |     1 |     8 |       |     2   (0)| 00:00:01 |

              |*145 |          INDEX UNIQUE SCAN                              | FND_USER_U1                    |     1 |       |       |     1   (0)| 00:00:01 |

              |*146 |         TABLE ACCESS BY INDEX ROWID BATCHED             | PA_PROJECTS_ALL                |     1 |    11 |       |     2   (0)| 00:00:01 |

              |*147 |          INDEX RANGE SCAN                               | PA_PROJECTS_U1                 |     1 |       |       |     1   (0)| 00:00:01 |

              |*148 |        TABLE ACCESS FULL                                | HR_ALL_ORGANIZATION_UNITS      |     1 |    13 |       |     6   (0)| 00:00:01 |

              |*149 |       TABLE ACCESS BY INDEX ROWID BATCHED               | PA_PROJECT_PARTIES             |     1 |    30 |       |     3   (0)| 00:00:01 |

              |*150 |        INDEX RANGE SCAN                                 | PA_PROJECT_PARTIES_U2          |     1 |       |       |     2   (0)| 00:00:01 |

              | 151 |       NESTED LOOPS                                      |                                |     1 |    92 |       |     4   (0)| 00:00:01 |

              | 152 |        TABLE ACCESS BY INDEX ROWID                      | FND_OBJECTS                    |     1 |    46 |       |     2   (0)| 00:00:01 |

              |*153 |         INDEX UNIQUE SCAN                               | FND_OBJECTS_U2                 |     1 |       |       |     1   (0)| 00:00:01 |

              |*154 |        TABLE ACCESS BY INDEX ROWID BATCHED              | FND_GRANTS                     |     1 |    46 |       |     2   (0)| 00:00:01 |

              |*155 |         INDEX RANGE SCAN                                | FND_GRANTS_N1                  |     1 |       |       |     1   (0)| 00:00:01 |

              |*156 |      HASH JOIN                                          |                                |     1 |    60 |       |   112   (1)| 00:00:01 |

              |*157 |       HASH JOIN OUTER                                   |                                |     1 |    31 |       |   105   (0)| 00:00:01 |

              |*158 |        TABLE ACCESS FULL                                | XXDW_PROJECTS_DTL_T            |     1 |    26 |       |    86   (0)| 00:00:01 |

              | 159 |        VIEW                                             |                                |     1 |     5 |       |    19   (0)| 00:00:01 |

              |*160 |         INDEX RANGE SCAN                                | XXDW_PROJECT_SUMMARY_N1        |     1 |    13 |       |     3   (0)| 00:00:01 |

              |*161 |          TABLE ACCESS FULL                              | XXDW_PERIODS_DIM               |     1 |    10 |       |     5   (0)| 00:00:01 |

              |*162 |       TABLE ACCESS FULL                                 | HR_ALL_ORGANIZATION_UNITS      |     5 |   145 |       |     6   (0)| 00:00:01 |

              --------------------------------------------------------------------------------------------------------------------------------------------------

               

              Query Block Name / Object Alias (identified by operation id):

              -------------------------------------------------------------

               

                 1 - SEL$335DD26A

                 4 - SEL$335DD26A / AID@SEL$2

                 5 - SEL$335DD26A / AID@SEL$2

                 6 - SEL$335DD26A / XXDW_TASKS_DIM_T@SEL$3

                 7 - SEL$335DD26A / XXDW_TASKS_DIM_T@SEL$3

                 8 - SEL$7286615E

                12 - SEL$7286615E / AID@SEL$4

                13 - SEL$7286615E / AID@SEL$4

                14 - SEL$7286615E / POD@SEL$4

                15 - SEL$7286615E / POD@SEL$4

                16 - SEL$7286615E / XXDW_TASKS_DIM_T@SEL$5

                17 - SEL$7286615E / XXDW_TASKS_DIM_T@SEL$5

                18 - SEL$68B588A0

                21 - SEL$68B588A0 / AID@SEL$6

                22 - SEL$68B588A0 / AID@SEL$6

                23 - SEL$68B588A0 / XXDW_TASKS_DIM_T@SEL$7

                24 - SEL$68B588A0 / XXDW_TASKS_DIM_T@SEL$7

                25 - SEL$CF5359D5

                29 - SEL$CF5359D5 / AID@SEL$8

                30 - SEL$CF5359D5 / AID@SEL$8

                31 - SEL$CF5359D5 / POD@SEL$8

                32 - SEL$CF5359D5 / POD@SEL$8

                33 - SEL$CF5359D5 / XXDW_TASKS_DIM_T@SEL$9

                34 - SEL$CF5359D5 / XXDW_TASKS_DIM_T@SEL$9

                35 - SEL$29     

                40 - SEL$29       / PRT@SEL$29

                41 - SEL$29       / PRT@SEL$29

                42 - SEL$29       / PPP@SEL$29

                43 - SEL$29       / PPP@SEL$29

                44 - SEL$29       / PAPF@SEL$29

                45 - SEL$29       / PAPF@SEL$29

                46 - SEL$30     

                51 - SEL$30       / PRT@SEL$30

                52 - SEL$30       / PPP@SEL$30

                53 - SEL$30       / PPP@SEL$30

                54 - SEL$30       / PAPF@SEL$30

                55 - SEL$30       / PAPF@SEL$30

                56 - SEL$31     

                61 - SEL$31       / PRT@SEL$31

                62 - SEL$31       / PPP@SEL$31

                63 - SEL$31       / PPP@SEL$31

                64 - SEL$31       / PAPF@SEL$31

                65 - SEL$31       / PAPF@SEL$31

                66 - SEL$11     

                67 - SEL$11       / APS@SEL$11

                68 - SEL$11       / APS@SEL$11

                69 - SEL$12     

                70 - SEL$12       / APS@SEL$12

                71 - SEL$12       / APS@SEL$12

                72 - SEL$13     

                73 - SEL$13       / PLL@SEL$13

                74 - SEL$13       / PLL@SEL$13

                75 - SEL$13       / PL@SEL$13

                76 - SEL$13       / PL@SEL$13

                77 - SEL$14     

                78 - SEL$14       / PLL@SEL$14

                79 - SEL$14       / PLL@SEL$14

                80 - SEL$14       / XBL@SEL$14

                81 - SEL$14       / XBL@SEL$14

                82 - SEL$10       / AP_EMP@SEL$10

                83 - SEL$10       / AP_EMP@SEL$10

                84 - SEL$57F89767

                96 - SEL$5EC70623 / AC@SEL$1

                97 - SEL$5EC70623

              100 - SEL$23     

              101 - SEL$23       / DUAL@SEL$23

              102 - SEL$45A549EF / SGID@SEL$21

              103 - SEL$45A549EF

              104 - SEL$45A549EF / KOKBF$0@SEL$24

              105 - SEL$5EC70623 / C@SEL$21

              106 - SEL$5EC70623 / C@SEL$21

              107 - SEL$26       / DUAL@SEL$26

              108 - SEL$25       / DUAL@SEL$25

              109 - SEL$5EC70623 / M@SEL$21

              110 - SEL$5EC70623 / M@SEL$21

              111 - SEL$57F89767 / AH@SEL$1

              112 - SEL$57F89767 / AH@SEL$1

              113 - SEL$57F89767 / AH@SEL$15

              114 - SEL$57F89767 / AI@SEL$1

              115 - SEL$57F89767 / AI@SEL$1

              116 - SEL$57F89767 / PAV@SEL$19

              117 - SEL$57F89767 / HP@SEL$19

              118 - SEL$27       / COMM_INFO@SEL$1

              119 - SEL$27     

              121 - SEL$27       / XXEXT_AP_HOLDS_COMMENTS@SEL$27

              122 - SEL$28       / PPA@SEL$1

              123 - SEL$28     

              127 - SEL$28       / PPA@SEL$28

              129 - SEL$28       / POD@SEL$28

              130 - SEL$28       / AID@SEL$28

              131 - SEL$32       / AIL@SEL$32

              132 - SEL$32       / AIL@SEL$32

              133 - SEL$18       / AHA@SEL$18

              134 - SEL$18       / AHA@SEL$18

              135 - SEL$16       / AH1@SEL$16

              136 - SEL$16       / AH1@SEL$16

              137 - SEL$17       / AH1@SEL$17

              138 - SEL$17       / AH1@SEL$17

              139 - SET$1      

              141 - SEL$4E97CFE8

              144 - SEL$4E97CFE8 / FND_USER@SEL$37

              145 - SEL$4E97CFE8 / FND_USER@SEL$37

              146 - SEL$4E97CFE8 / PPA@SEL$36

              147 - SEL$4E97CFE8 / PPA@SEL$36

              148 - SEL$5A0C3989 / HAOU@SEL$41

              149 - SEL$38       / PA_PROJECT_PARTIES@SEL$38

              150 - SEL$38       / PA_PROJECT_PARTIES@SEL$38

              151 - SEL$39     

              152 - SEL$39       / FO@SEL$39

              153 - SEL$39       / FO@SEL$39

              154 - SEL$39       / FG@SEL$39

              155 - SEL$39       / FG@SEL$39

              156 - SEL$D4FC0C78

              158 - SEL$D4FC0C78 / XPD@SEL$43

              159 - SEL$6181ABC9 / BUDGET@SEL$43

              160 - SEL$6181ABC9 / SUB_QUERY@SEL$46

              161 - SEL$56       / XXDW_PERIODS_DIM@SEL$56

              162 - SEL$D4FC0C78 / HAOU@SEL$57

               

              Outline Data

              -------------

               

                /*+

                    BEGIN_OUTLINE_DATA

                    IGNORE_OPTIM_EMBEDDED_HINTS

                    OPTIMIZER_FEATURES_ENABLE('12.1.0.2')

                    DB_VERSION('12.1.0.2')

                    OPT_PARAM('_b_tree_bitmap_plans' 'false')

                    OPT_PARAM('_fast_full_scan_enabled' 'false')

                    ALL_ROWS

                    FORCE_XML_QUERY_REWRITE

                    XML_DML_RWT_STMT

                    XMLINDEX_REWRITE

                    XMLINDEX_REWRITE_IN_SELECT

                    NO_COST_XML_QUERY_REWRITE

                    OUTLINE_LEAF(@"SEL$5A0C3989")

                    MERGE(@"SEL$41")

                    OUTLINE_LEAF(@"SEL$38")

                    OUTLINE_LEAF(@"SEL$39")

                    OUTLINE_LEAF(@"SEL$4E97CFE8")

                    MERGE(@"SEL$FF4A7D68")

                    OUTLINE_LEAF(@"SEL$56")

                    OUTLINE_LEAF(@"SEL$47")

                    OUTLINE_LEAF(@"SEL$49")

                    OUTLINE_LEAF(@"SEL$6181ABC9")

                    MERGE(@"SEL$B3FB865B")

                    OUTLINE_LEAF(@"SEL$D4FC0C78")

                    MERGE(@"SEL$43")

                    MERGE(@"SEL$57")

                    OUTLINE_LEAF(@"SET$1")

                    OUTLINE_LEAF(@"SEL$335DD26A")

                    MERGE(@"SEL$3")

                    OUTLINE_LEAF(@"SEL$7286615E")

                    MERGE(@"SEL$5")

                    OUTLINE_LEAF(@"SEL$68B588A0")

                    MERGE(@"SEL$7")

                    OUTLINE_LEAF(@"SEL$CF5359D5")

                    MERGE(@"SEL$9")

                    OUTLINE_LEAF(@"SEL$10")

                    OUTLINE_LEAF(@"SEL$11")

                    OUTLINE_LEAF(@"SEL$12")

                    OUTLINE_LEAF(@"SEL$13")

                    OUTLINE_LEAF(@"SEL$14")

                    OUTLINE_LEAF(@"SEL$16")

                    OUTLINE_LEAF(@"SEL$17")

                    OUTLINE_LEAF(@"SEL$18")

                    OUTLINE_LEAF(@"SEL$25")

                    OUTLINE_LEAF(@"SEL$26")

                    OUTLINE_LEAF(@"SEL$23")

                    OUTLINE_LEAF(@"SEL$45A549EF")

                    MERGE(@"SEL$24")

                    OUTLINE_LEAF(@"SEL$5EC70623")

                    MERGE(@"SEL$21")

                    OUTLINE_LEAF(@"SEL$27")

                    OUTLINE_LEAF(@"SEL$29")

                    OUTLINE_LEAF(@"SEL$30")

                    OUTLINE_LEAF(@"SEL$31")

                    OUTLINE_LEAF(@"SEL$32")

                    OUTLINE_LEAF(@"SEL$28")

                    OUTLINE_LEAF(@"SEL$57F89767")

                    MERGE(@"SEL$937E33EF")

                    OUTLINE(@"SEL$40")

                    OUTLINE(@"SEL$41")

                    OUTLINE(@"SEL$35")

                    OUTLINE(@"SEL$FF4A7D68")

                    MERGE(@"SEL$37")

                    OUTLINE(@"SEL$44")

                    OUTLINE(@"SEL$B3FB865B")

                    MERGE(@"SEL$46")

                    OUTLINE(@"SEL$42")

                    OUTLINE(@"SEL$43")

                    OUTLINE(@"SEL$57")

                    OUTLINE(@"SEL$2")

                    OUTLINE(@"SEL$3")

                    OUTLINE(@"SEL$4")

                    OUTLINE(@"SEL$5")

                    OUTLINE(@"SEL$6")

                    OUTLINE(@"SEL$7")

                    OUTLINE(@"SEL$8")

                    OUTLINE(@"SEL$9")

                    OUTLINE(@"SEL$22")

                    OUTLINE(@"SEL$24")

                    OUTLINE(@"SEL$20")

                    OUTLINE(@"SEL$21")

                    OUTLINE(@"SEL$33")

                    OUTLINE(@"SEL$937E33EF")

                    MERGE(@"SEL$577DDB82")

                    OUTLINE(@"SEL$36")

                    OUTLINE(@"SEL$37")

                    OUTLINE(@"SEL$45")

                    OUTLINE(@"SEL$46")

                    OUTLINE(@"SEL$34")

                    OUTLINE(@"SEL$577DDB82")

                    MERGE(@"SEL$15")

                    MERGE(@"SEL$19")

                    OUTLINE(@"SEL$1")

                    OUTLINE(@"SEL$15")

                    OUTLINE(@"SEL$19")

                    INDEX_SS(@"SEL$57F89767" "AH"@"SEL$1" ("AP_HOLDS_ALL"."INVOICE_ID" "AP_HOLDS_ALL"."RELEASE_LOOKUP_CODE"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$57F89767" "AH"@"SEL$1")

                    NO_ACCESS(@"SEL$57F89767" "AC"@"SEL$1")

                    FULL(@"SEL$57F89767" "AH"@"SEL$15")

                    INDEX(@"SEL$57F89767" "AI"@"SEL$1" ("AP_INVOICES_ALL"."INVOICE_ID"))

                    FULL(@"SEL$57F89767" "PAV"@"SEL$19")

                    INDEX(@"SEL$57F89767" "HP"@"SEL$19" ("HZ_PARTIES"."PARTY_ID"))

                    NO_ACCESS(@"SEL$57F89767" "COMM_INFO"@"SEL$1")

                    NO_ACCESS(@"SEL$57F89767" "PPA"@"SEL$1")

                    LEADING(@"SEL$57F89767" "AH"@"SEL$1" "AC"@"SEL$1" "AH"@"SEL$15" "AI"@"SEL$1" "PAV"@"SEL$19" "HP"@"SEL$19" "COMM_INFO"@"SEL$1"

                            "PPA"@"SEL$1")

                    USE_HASH(@"SEL$57F89767" "AC"@"SEL$1")

                    USE_HASH(@"SEL$57F89767" "AH"@"SEL$15")

                    USE_NL(@"SEL$57F89767" "AI"@"SEL$1")

                    NLJ_BATCHING(@"SEL$57F89767" "AI"@"SEL$1")

                    USE_HASH(@"SEL$57F89767" "PAV"@"SEL$19")

                    USE_NL(@"SEL$57F89767" "HP"@"SEL$19")

                    USE_HASH(@"SEL$57F89767" "COMM_INFO"@"SEL$1")

                    USE_HASH(@"SEL$57F89767" "PPA"@"SEL$1")

                    PX_JOIN_FILTER(@"SEL$57F89767" "COMM_INFO"@"SEL$1")

                    PX_JOIN_FILTER(@"SEL$57F89767" "PPA"@"SEL$1")

                    SWAP_JOIN_INPUTS(@"SEL$57F89767" "AC"@"SEL$1")

                    PQ_FILTER(@"SEL$57F89767" SERIAL)

                    NO_ACCESS(@"SEL$5EC70623" "SGID"@"SEL$21")

                    INDEX_RS_ASC(@"SEL$5EC70623" "C"@"SEL$21" ("WWV_FLOW_COLLECTIONS$"."SESSION_ID" "WWV_FLOW_COLLECTIONS$"."USER_ID"

                            "WWV_FLOW_COLLECTIONS$"."FLOW_ID" "WWV_FLOW_COLLECTIONS$"."COLLECTION_NAME" "WWV_FLOW_COLLECTIONS$"."SECURITY_GROUP_ID"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$5EC70623" "C"@"SEL$21")

                    INDEX(@"SEL$5EC70623" "M"@"SEL$21" ("WWV_FLOW_COLLECTION_MEMBERS$"."COLLECTION_ID" "WWV_FLOW_COLLECTION_MEMBERS$"."SEQ_ID"

                            "WWV_FLOW_COLLECTION_MEMBERS$"."SECURITY_GROUP_ID"))

                    LEADING(@"SEL$5EC70623" "SGID"@"SEL$21" "C"@"SEL$21" "M"@"SEL$21")

                    USE_NL(@"SEL$5EC70623" "C"@"SEL$21")

                    USE_NL(@"SEL$5EC70623" "M"@"SEL$21")

                    NLJ_BATCHING(@"SEL$5EC70623" "M"@"SEL$21")

                    PUSH_SUBQ(@"SEL$26")

                    PUSH_SUBQ(@"SEL$25")

                    FULL(@"SEL$27" "XXEXT_AP_HOLDS_COMMENTS"@"SEL$27")

                    USE_HASH_AGGREGATION(@"SEL$27")

                    FULL(@"SEL$28" "AID"@"SEL$28")

                    INDEX(@"SEL$28" "POD"@"SEL$28" ("PO_DISTRIBUTIONS_ALL"."PROJECT_ID" "PO_DISTRIBUTIONS_ALL"."EXPENDITURE_ITEM_DATE"

                            "PO_DISTRIBUTIONS_ALL"."PO_DISTRIBUTION_ID" "PO_DISTRIBUTIONS_ALL"."ACCRUE_ON_RECEIPT_FLAG" "PO_DISTRIBUTIONS_ALL"."DISTRIBUTION_TYPE"))

                    FULL(@"SEL$28" "PPA"@"SEL$28")

                    LEADING(@"SEL$28" "AID"@"SEL$28" "POD"@"SEL$28" "PPA"@"SEL$28")

                    USE_HASH(@"SEL$28" "POD"@"SEL$28")

                    USE_HASH(@"SEL$28" "PPA"@"SEL$28")

                    SWAP_JOIN_INPUTS(@"SEL$28" "POD"@"SEL$28")

                    SWAP_JOIN_INPUTS(@"SEL$28" "PPA"@"SEL$28")

                    USE_HASH_AGGREGATION(@"SEL$28")

                    PQ_FILTER(@"SEL$28" SERIAL)

                    INDEX_RS_ASC(@"SEL$32" "AIL"@"SEL$32" ("AP_INVOICE_LINES_ALL"."INVOICE_ID" "AP_INVOICE_LINES_ALL"."LINE_NUMBER"))

                    FULL(@"SEL$31" "PRT"@"SEL$31")

                    INDEX_RS_ASC(@"SEL$31" "PPP"@"SEL$31" ("PA_PROJECT_PARTIES"."PROJECT_ID" "PA_PROJECT_PARTIES"."PROJECT_ROLE_ID"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$31" "PPP"@"SEL$31")

                    INDEX(@"SEL$31" "PAPF"@"SEL$31" ("PER_ALL_PEOPLE_F"."PERSON_ID" "PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE"

                            "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE"))

                    LEADING(@"SEL$31" "PRT"@"SEL$31" "PPP"@"SEL$31" "PAPF"@"SEL$31")

                    USE_NL(@"SEL$31" "PPP"@"SEL$31")

                    USE_NL(@"SEL$31" "PAPF"@"SEL$31")

                    NLJ_BATCHING(@"SEL$31" "PAPF"@"SEL$31")

                    FULL(@"SEL$30" "PRT"@"SEL$30")

                    INDEX_RS_ASC(@"SEL$30" "PPP"@"SEL$30" ("PA_PROJECT_PARTIES"."PROJECT_ID" "PA_PROJECT_PARTIES"."PROJECT_ROLE_ID"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$30" "PPP"@"SEL$30")

                    INDEX(@"SEL$30" "PAPF"@"SEL$30" ("PER_ALL_PEOPLE_F"."PERSON_ID" "PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE"

                            "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE"))

                    LEADING(@"SEL$30" "PRT"@"SEL$30" "PPP"@"SEL$30" "PAPF"@"SEL$30")

                    USE_NL(@"SEL$30" "PPP"@"SEL$30")

                    USE_NL(@"SEL$30" "PAPF"@"SEL$30")

                    NLJ_BATCHING(@"SEL$30" "PAPF"@"SEL$30")

                    INDEX_RS_ASC(@"SEL$29" "PRT"@"SEL$29" ("PA_PROJECT_ROLE_TYPES_TL"."MEANING" "PA_PROJECT_ROLE_TYPES_TL"."LANGUAGE"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$29" "PRT"@"SEL$29")

                    INDEX_RS_ASC(@"SEL$29" "PPP"@"SEL$29" ("PA_PROJECT_PARTIES"."PROJECT_ID" "PA_PROJECT_PARTIES"."PROJECT_ROLE_ID"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$29" "PPP"@"SEL$29")

                    INDEX(@"SEL$29" "PAPF"@"SEL$29" ("PER_ALL_PEOPLE_F"."PERSON_ID" "PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE"

                            "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE"))

                    LEADING(@"SEL$29" "PRT"@"SEL$29" "PPP"@"SEL$29" "PAPF"@"SEL$29")

                    USE_NL(@"SEL$29" "PPP"@"SEL$29")

                    USE_NL(@"SEL$29" "PAPF"@"SEL$29")

                    NLJ_BATCHING(@"SEL$29" "PAPF"@"SEL$29")

                    FULL(@"SEL$45A549EF" "KOKBF$0"@"SEL$24")

                    INDEX_RS_ASC(@"SEL$18" "AHA"@"SEL$18" ("AP_HOLDS_ALL"."INVOICE_ID" "AP_HOLDS_ALL"."RELEASE_LOOKUP_CODE"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$18" "AHA"@"SEL$18")

                    INDEX_RS_ASC(@"SEL$17" "AH1"@"SEL$17" ("AP_HOLDS_ALL"."INVOICE_ID" "AP_HOLDS_ALL"."RELEASE_LOOKUP_CODE"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$17" "AH1"@"SEL$17")

                    INDEX_RS_ASC(@"SEL$16" "AH1"@"SEL$16" ("AP_HOLDS_ALL"."INVOICE_ID" "AP_HOLDS_ALL"."RELEASE_LOOKUP_CODE"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$16" "AH1"@"SEL$16")

                    INDEX_RS_ASC(@"SEL$14" "PLL"@"SEL$14" ("PO_LINE_LOCATIONS_ALL"."LINE_LOCATION_ID"))

                    INDEX_RS_ASC(@"SEL$14" "XBL"@"SEL$14" ("XXPD_BOM_LINES"."LINE_ID"))

                    LEADING(@"SEL$14" "PLL"@"SEL$14" "XBL"@"SEL$14")

                    USE_NL(@"SEL$14" "XBL"@"SEL$14")

                    INDEX_RS_ASC(@"SEL$13" "PLL"@"SEL$13" ("PO_LINE_LOCATIONS_ALL"."LINE_LOCATION_ID"))

                    INDEX_RS_ASC(@"SEL$13" "PL"@"SEL$13" ("PO_LINES_ALL"."PO_LINE_ID"))

                    LEADING(@"SEL$13" "PLL"@"SEL$13" "PL"@"SEL$13")

                    USE_NL(@"SEL$13" "PL"@"SEL$13")

                    INDEX_RS_ASC(@"SEL$12" "APS"@"SEL$12" ("AP_PAYMENT_SCHEDULES_ALL"."INVOICE_ID" "AP_PAYMENT_SCHEDULES_ALL"."PAYMENT_NUM"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$12" "APS"@"SEL$12")

                    INDEX_RS_ASC(@"SEL$11" "APS"@"SEL$11" ("AP_PAYMENT_SCHEDULES_ALL"."INVOICE_ID" "AP_PAYMENT_SCHEDULES_ALL"."PAYMENT_NUM"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$11" "APS"@"SEL$11")

                    INDEX_RS_ASC(@"SEL$10" "AP_EMP"@"SEL$10" ("PER_ALL_PEOPLE_F"."PERSON_ID" "PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE"

                            "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$10" "AP_EMP"@"SEL$10")

                    INDEX_RS_ASC(@"SEL$CF5359D5" "AID"@"SEL$8" ("AP_INVOICE_DISTRIBUTIONS_ALL"."INVOICE_ID"

                            "AP_INVOICE_DISTRIBUTIONS_ALL"."OLD_DIST_LINE_NUMBER"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$CF5359D5" "AID"@"SEL$8")

                    INDEX_RS_ASC(@"SEL$CF5359D5" "POD"@"SEL$8" ("PO_DISTRIBUTIONS_ALL"."PO_DISTRIBUTION_ID"))

                    INDEX(@"SEL$CF5359D5" "XXDW_TASKS_DIM_T"@"SEL$9" ("XXDW_TASKS_DIM_T"."PROJECT_ID" "XXDW_TASKS_DIM_T"."TASK_ID"))

                    LEADING(@"SEL$CF5359D5" "AID"@"SEL$8" "POD"@"SEL$8" "XXDW_TASKS_DIM_T"@"SEL$9")

                    USE_NL(@"SEL$CF5359D5" "POD"@"SEL$8")

                    USE_NL(@"SEL$CF5359D5" "XXDW_TASKS_DIM_T"@"SEL$9")

                    NLJ_BATCHING(@"SEL$CF5359D5" "XXDW_TASKS_DIM_T"@"SEL$9")

                    INDEX_RS_ASC(@"SEL$68B588A0" "AID"@"SEL$6" ("AP_INVOICE_DISTRIBUTIONS_ALL"."INVOICE_ID"

                            "AP_INVOICE_DISTRIBUTIONS_ALL"."OLD_DIST_LINE_NUMBER"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$68B588A0" "AID"@"SEL$6")

                    INDEX(@"SEL$68B588A0" "XXDW_TASKS_DIM_T"@"SEL$7" ("XXDW_TASKS_DIM_T"."PROJECT_ID" "XXDW_TASKS_DIM_T"."TASK_ID"))

                    LEADING(@"SEL$68B588A0" "AID"@"SEL$6" "XXDW_TASKS_DIM_T"@"SEL$7")

                    USE_NL(@"SEL$68B588A0" "XXDW_TASKS_DIM_T"@"SEL$7")

                    NLJ_BATCHING(@"SEL$68B588A0" "XXDW_TASKS_DIM_T"@"SEL$7")

                    INDEX_RS_ASC(@"SEL$7286615E" "AID"@"SEL$4" ("AP_INVOICE_DISTRIBUTIONS_ALL"."INVOICE_ID"

                            "AP_INVOICE_DISTRIBUTIONS_ALL"."OLD_DIST_LINE_NUMBER"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$7286615E" "AID"@"SEL$4")

                    INDEX_RS_ASC(@"SEL$7286615E" "POD"@"SEL$4" ("PO_DISTRIBUTIONS_ALL"."PO_DISTRIBUTION_ID"))

                    INDEX(@"SEL$7286615E" "XXDW_TASKS_DIM_T"@"SEL$5" ("XXDW_TASKS_DIM_T"."PROJECT_ID" "XXDW_TASKS_DIM_T"."TASK_ID"))

                    LEADING(@"SEL$7286615E" "AID"@"SEL$4" "POD"@"SEL$4" "XXDW_TASKS_DIM_T"@"SEL$5")

                    USE_NL(@"SEL$7286615E" "POD"@"SEL$4")

                    USE_NL(@"SEL$7286615E" "XXDW_TASKS_DIM_T"@"SEL$5")

                    NLJ_BATCHING(@"SEL$7286615E" "XXDW_TASKS_DIM_T"@"SEL$5")

                    INDEX_RS_ASC(@"SEL$335DD26A" "AID"@"SEL$2" ("AP_INVOICE_DISTRIBUTIONS_ALL"."INVOICE_ID"

                            "AP_INVOICE_DISTRIBUTIONS_ALL"."OLD_DIST_LINE_NUMBER"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$335DD26A" "AID"@"SEL$2")

                    INDEX(@"SEL$335DD26A" "XXDW_TASKS_DIM_T"@"SEL$3" ("XXDW_TASKS_DIM_T"."PROJECT_ID" "XXDW_TASKS_DIM_T"."TASK_ID"))

                    LEADING(@"SEL$335DD26A" "AID"@"SEL$2" "XXDW_TASKS_DIM_T"@"SEL$3")

                    USE_NL(@"SEL$335DD26A" "XXDW_TASKS_DIM_T"@"SEL$3")

                    NLJ_BATCHING(@"SEL$335DD26A" "XXDW_TASKS_DIM_T"@"SEL$3")

                    FULL(@"SEL$D4FC0C78" "XPD"@"SEL$43")

                    NO_ACCESS(@"SEL$D4FC0C78" "BUDGET"@"SEL$43")

                    FULL(@"SEL$D4FC0C78" "HAOU"@"SEL$57")

                    LEADING(@"SEL$D4FC0C78" "XPD"@"SEL$43" "BUDGET"@"SEL$43" "HAOU"@"SEL$57")

                    USE_HASH(@"SEL$D4FC0C78" "BUDGET"@"SEL$43")

                    USE_HASH(@"SEL$D4FC0C78" "HAOU"@"SEL$57")

                    INDEX_RS_ASC(@"SEL$4E97CFE8" "FND_USER"@"SEL$37" ("FND_USER"."USER_ID"))

                    INDEX_RS_ASC(@"SEL$4E97CFE8" "PPA"@"SEL$36" ("PA_PROJECTS_ALL"."PROJECT_ID" "PA_PROJECTS_ALL"."SEGMENT1"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$4E97CFE8" "PPA"@"SEL$36")

                    LEADING(@"SEL$4E97CFE8" "FND_USER"@"SEL$37" "PPA"@"SEL$36")

                    USE_NL(@"SEL$4E97CFE8" "PPA"@"SEL$36")

                    PQ_FILTER(@"SEL$4E97CFE8" SERIAL)

                    INDEX_RS_ASC(@"SEL$39" "FO"@"SEL$39" ("FND_OBJECTS"."OBJ_NAME"))

                    INDEX_RS_ASC(@"SEL$39" "FG"@"SEL$39" ("FND_GRANTS"."GRANTEE_TYPE" "FND_GRANTS"."GRANTEE_KEY"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$39" "FG"@"SEL$39")

                    LEADING(@"SEL$39" "FO"@"SEL$39" "FG"@"SEL$39")

                    USE_NL(@"SEL$39" "FG"@"SEL$39")

                    INDEX_RS_ASC(@"SEL$38" "PA_PROJECT_PARTIES"@"SEL$38" ("PA_PROJECT_PARTIES"."OBJECT_ID" "PA_PROJECT_PARTIES"."OBJECT_TYPE"

                            "PA_PROJECT_PARTIES"."RESOURCE_TYPE_ID" "PA_PROJECT_PARTIES"."RESOURCE_SOURCE_ID" "PA_PROJECT_PARTIES"."PROJECT_ROLE_ID"

                            "PA_PROJECT_PARTIES"."START_DATE_ACTIVE"))

                    BATCH_TABLE_ACCESS_BY_ROWID(@"SEL$38" "PA_PROJECT_PARTIES"@"SEL$38")

                    FULL(@"SEL$5A0C3989" "HAOU"@"SEL$41")

                    INDEX(@"SEL$6181ABC9" "SUB_QUERY"@"SEL$46" ("XXDW_PROJECT_SUMMARY_T"."PROJECT_ID" "XXDW_PROJECT_SUMMARY_T"."END_DATE"))

                    PUSH_SUBQ(@"SEL$56")

                    FULL(@"SEL$49" "PPA"@"SEL$49")

                    INDEX(@"SEL$49" "XPS"@"SEL$49" ("XXDW_PROJECT_SUMMARY_T"."PROJECT_ID" "XXDW_PROJECT_SUMMARY_T"."END_DATE"))

                    LEADING(@"SEL$49" "PPA"@"SEL$49" "XPS"@"SEL$49")

                    USE_NL(@"SEL$49" "XPS"@"SEL$49")

                    NLJ_BATCHING(@"SEL$49" "XPS"@"SEL$49")

                    FULL(@"SEL$47" "PPA"@"SEL$47")

                    INDEX(@"SEL$47" "XPS"@"SEL$47" ("XXDW_PROJECT_SUMMARY_T"."PROJECT_ID" "XXDW_PROJECT_SUMMARY_T"."END_DATE"))

                    LEADING(@"SEL$47" "PPA"@"SEL$47" "XPS"@"SEL$47")

                    USE_NL(@"SEL$47" "XPS"@"SEL$47")

                    NLJ_BATCHING(@"SEL$47" "XPS"@"SEL$47")

                    FULL(@"SEL$56" "XXDW_PERIODS_DIM"@"SEL$56")

                    END_OUTLINE_DATA

                */

               

              Peeked Binds (identified by position):

              --------------------------------------

               

                17 - :F_USER_NAME (VARCHAR2(30), CSID=871): (null)

               

              Predicate Information (identified by operation id):

              ---------------------------------------------------

               

                 1 - filter(ROWNUM<2)

                 4 - filter(NVL("AID"."REVERSAL_FLAG",'N')='N')

                 5 - access("AID"."INVOICE_ID"=:B1)

                 6 - access("PROJECT_ID"="AID"."PROJECT_ID")

                 8 - filter(ROWNUM<2)

                12 - filter(("AID"."PO_DISTRIBUTION_ID" IS NOT NULL AND NVL("AID"."REVERSAL_FLAG",'N')='N'))

                13 - access("AID"."INVOICE_ID"=:B1)

                15 - access("POD"."PO_DISTRIBUTION_ID"="AID"."PO_DISTRIBUTION_ID")

                16 - access("PROJECT_ID"="POD"."PROJECT_ID")

                18 - filter(ROWNUM<2)

                21 - filter(NVL("AID"."REVERSAL_FLAG",'N')='N')

                22 - access("AID"."INVOICE_ID"=:B1)

                23 - access("PROJECT_ID"="AID"."PROJECT_ID")

                25 - filter(ROWNUM<2)

                29 - filter(("AID"."PO_DISTRIBUTION_ID" IS NOT NULL AND NVL("AID"."REVERSAL_FLAG",'N')='N'))

                30 - access("AID"."INVOICE_ID"=:B1)

                32 - access("POD"."PO_DISTRIBUTION_ID"="AID"."PO_DISTRIBUTION_ID")

                33 - access("PROJECT_ID"="POD"."PROJECT_ID")

                36 - filter(ROWNUM<2)

                41 - access("PRT"."MEANING"='PDI Project Executive')

                42 - filter(("PPP"."START_DATE_ACTIVE"<=SYSDATE@! AND NVL("PPP"."END_DATE_ACTIVE",TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd

                            hh24:mi:ss'))>=SYSDATE@!))

                43 - access("PPP"."PROJECT_ID"=:B1 AND "PPP"."PROJECT_ROLE_ID"="PRT"."PROJECT_ROLE_ID")

                44 - access("PAPF"."PERSON_ID"="PPP"."RESOURCE_SOURCE_ID" AND "PAPF"."EFFECTIVE_END_DATE">=SYSDATE@! AND

                            "PAPF"."EFFECTIVE_START_DATE"<=SYSDATE@!)

                     filter("PAPF"."EFFECTIVE_END_DATE">=SYSDATE@!)

                47 - filter(ROWNUM<2)

                51 - filter(UPPER("PRT"."MEANING") LIKE '%PROJECT ENGINEER%')

                52 - filter(("PPP"."START_DATE_ACTIVE"<=SYSDATE@! AND NVL("PPP"."END_DATE_ACTIVE",TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd

                            hh24:mi:ss'))>=SYSDATE@!))

                53 - access("PPP"."PROJECT_ID"=:B1 AND "PPP"."PROJECT_ROLE_ID"="PRT"."PROJECT_ROLE_ID")

                54 - access("PAPF"."PERSON_ID"="PPP"."RESOURCE_SOURCE_ID" AND "PAPF"."EFFECTIVE_END_DATE">=SYSDATE@! AND

                            "PAPF"."EFFECTIVE_START_DATE"<=SYSDATE@!)

                     filter("PAPF"."EFFECTIVE_END_DATE">=SYSDATE@!)

                57 - filter(ROWNUM<2)

                61 - filter(UPPER("PRT"."MEANING") LIKE '%PDI ASST PROJECT MANAGER%')

                62 - filter(("PPP"."START_DATE_ACTIVE"<=SYSDATE@! AND NVL("PPP"."END_DATE_ACTIVE",TO_DATE(' 4712-12-31 00:00:00', 'syyyy-mm-dd

                            hh24:mi:ss'))>=SYSDATE@!))

                63 - access("PPP"."PROJECT_ID"=:B1 AND "PPP"."PROJECT_ROLE_ID"="PRT"."PROJECT_ROLE_ID")

                64 - access("PAPF"."PERSON_ID"="PPP"."RESOURCE_SOURCE_ID" AND "PAPF"."EFFECTIVE_END_DATE">=SYSDATE@! AND

                            "PAPF"."EFFECTIVE_START_DATE"<=SYSDATE@!)

                     filter("PAPF"."EFFECTIVE_END_DATE">=SYSDATE@!)

                68 - access("APS"."INVOICE_ID"=:B1)

                71 - access("APS"."INVOICE_ID"=:B1)

                74 - access("PLL"."LINE_LOCATION_ID"=:B1)

                76 - access("PLL"."PO_LINE_ID"="PL"."PO_LINE_ID")

                79 - access("PLL"."LINE_LOCATION_ID"=:B1)

                81 - access("XBL"."LINE_ID"=TO_NUMBER("PLL"."ATTRIBUTE15"))

                83 - access("AP_EMP"."PERSON_ID"=TO_NUMBER(:B1) AND "AP_EMP"."EFFECTIVE_END_DATE">=SYSDATE@! AND

                            "AP_EMP"."EFFECTIVE_START_DATE"<=SYSDATE@!)

                     filter("AP_EMP"."EFFECTIVE_END_DATE">=SYSDATE@!)

                85 - filter(((INTERNAL_FUNCTION("AH"."HOLD_REASON") OR ( IS NULL AND INTERNAL_FUNCTION("AH"."HOLD_REASON")) OR

                            (INTERNAL_FUNCTION("AH"."HOLD_REASON") AND  IS NULL AND  IS NULL)) AND (("PPA"."PROJECT_ID" IS NULL AND TO_NUMBER(:F_IS_AP)=1) OR

                            ("PPA"."PROJECT_ID" IS NOT NULL AND (TO_NUMBER(:F_IS_AP)=1 OR TO_NUMBER(:F_IS_LPM)=1)) OR  IS NOT NULL)))

                86 - access("PPA"."INVOICE_ID"="AI"."INVOICE_ID")

                88 - access("COMM_INFO"."HOLD_ID"="AH"."HOLD_ID")

                91 - access("PAV"."VENDOR_ID"="AI"."VENDOR_ID")

                94 - access("AH"."HOLD_ID"="AH"."HOLD_ID")

                95 - access("AC"."HOLD_ID"="AH"."HOLD_ID")

              100 - filter(ROWNUM=1)

              103 - filter(ROWNUM=1)

              106 - access("C"."SESSION_ID"=TO_NUMBER() AND "C"."FLOW_ID"= AND "C"."COLLECTION_NAME"='ALL_HOLDS' AND

                            "C"."SECURITY_GROUP_ID"="SGID"."SECURITY_GROUP_ID")

                     filter(("C"."COLLECTION_NAME"='ALL_HOLDS' AND "C"."SECURITY_GROUP_ID"="SGID"."SECURITY_GROUP_ID" AND "C"."FLOW_ID"=))

              109 - access("C"."ID"="M"."COLLECTION_ID")

              112 - access("AH"."RELEASE_LOOKUP_CODE" IS NULL)

                     filter("AH"."RELEASE_LOOKUP_CODE" IS NULL)

              114 - access("AH"."INVOICE_ID"="AI"."INVOICE_ID")

              117 - access("PAV"."PARTY_ID"="HP"."PARTY_ID")

              121 - filter(SYS_OP_BLOOM_FILTER(:BF0000,"HOLD_ID"))

              124 - filter( IS NULL)

              126 - access("PPA"."PROJECT_ID"=NVL("POD"."PROJECT_ID","AID"."PROJECT_ID"))

              128 - access("POD"."PO_DISTRIBUTION_ID"="AID"."PO_DISTRIBUTION_ID")

              130 - filter(NVL("AID"."REVERSAL_FLAG",'N')='N')

              131 - filter(NVL("AIL"."DISCARDED_FLAG",'N')='Y')

              132 - access("AIL"."INVOICE_ID"=:B1 AND "AIL"."LINE_NUMBER"=:B2)

              133 - filter(("AHA"."HOLD_REASON"='Invoice has invalid or missing PO number' OR "AHA"."HOLD_REASON"='Invoice is not matched to any PO'

                            OR "AHA"."HOLD_REASON"='Lines on inv not on PO' OR "AHA"."HOLD_REASON"='Lot PO setup incorrectly' OR "AHA"."HOLD_REASON"='PO Cancelled'

                            OR "AHA"."HOLD_REASON"='PO To Wrong Vendor' OR "AHA"."HOLD_REASON"='PO has not been approved' OR "AHA"."HOLD_REASON"='PO is complete' OR

                            "AHA"."HOLD_REASON"='Total of Invoice Lines does not equal Invoice Amount'))

              134 - access("AHA"."INVOICE_ID"=:B1 AND "AHA"."RELEASE_LOOKUP_CODE" IS NULL)

              135 - filter(("AH1"."HOLD_REASON"='Approval Pending' OR "AH1"."HOLD_REASON"='Credit Needs Research' OR "AH1"."HOLD_REASON"='Distribution

                            account is invalid' OR "AH1"."HOLD_REASON"='Invoice amount exceeded limit' OR "AH1"."HOLD_REASON"='Line does not contain enough data to

                            produce distributions' OR "AH1"."HOLD_REASON"='Line references a skeleton Distribution Set' OR "AH1"."HOLD_REASON"='Line references an

                            inactive Distribution Set' OR "AH1"."HOLD_REASON"='PO has been over billed' OR "AH1"."HOLD_REASON"='PO is Complete' OR

                            "AH1"."HOLD_REASON"='Project Hold' OR "AH1"."HOLD_REASON"='Return invoice to vendor' OR "AH1"."HOLD_REASON"='Subcontractor cannot be paid

                            until the customer pays' OR "AH1"."HOLD_REASON"='Sum of invoice and exchange rate variances exceeds limit'))

              136 - access("AH1"."INVOICE_ID"=:B1 AND "AH1"."RELEASE_LOOKUP_CODE" IS NULL)

              137 - filter(("AH1"."HOLD_REASON"='Credit Need RGA' OR "AH1"."HOLD_REASON"='Credit Needs Research' OR "AH1"."HOLD_REASON"='Freight Needs

                            Approval' OR "AH1"."HOLD_REASON"='Invoice has invalid or missing PO number' OR "AH1"."HOLD_REASON"='Lines on inv not on PO' OR

                            "AH1"."HOLD_REASON"='Lot PO setup incorrectly' OR "AH1"."HOLD_REASON"='Open RGA waiting on credit' OR "AH1"."HOLD_REASON"='PO Cancelled'

                            OR "AH1"."HOLD_REASON"='PO To Wrong Vendor' OR "AH1"."HOLD_REASON"='PO has been over billed' OR "AH1"."HOLD_REASON"='PO has not been

                            approved' OR "AH1"."HOLD_REASON"='PO is complete' OR "AH1"."HOLD_REASON"='RGA Pending Credit'))

              138 - access("AH1"."INVOICE_ID"=:B1 AND "AH1"."RELEASE_LOOKUP_CODE" IS NULL)

              141 - filter(("FND_PROFILE"."VALUE_SPECIFIC"('PA_SUPER_PROJECT',"USER_ID")='Y' OR

                            "FND_PROFILE"."VALUE_SPECIFIC"('PA_SUPER_PROJECT_VIEW',"USER_ID")='Y' OR  IS NOT NULL OR  IS NOT NULL))

              142 - filter( IS NULL)

              145 - access("USER_ID"="FND_GLOBAL"."USER_ID"())

              146 - filter("PPA"."TEMPLATE_FLAG"='N')

              147 - access("PPA"."PROJECT_ID"=:B1)

              148 - filter((UPPER("HAOU"."ATTRIBUTE2")='OPERATIONS' AND UPPER("HAOU"."ATTRIBUTE1")=UPPER(:F_USER_NAME)))

              149 - filter("PROJECT_ID"=:B1)

              150 - access("OBJECT_ID"=:B1 AND "OBJECT_TYPE"='PA_PROJECTS' AND "RESOURCE_TYPE_ID"=DECODE(TO_CHAR(:B2),NULL,112,101) AND

                            "RESOURCE_SOURCE_ID"=DECODE(TO_CHAR(:B3),NULL,"PA_UTILS"."GET_PARTY_ID"(:B4),:B5))

              153 - access("FO"."OBJ_NAME"='ORGANIZATION')

              154 - filter(("FG"."INSTANCE_TYPE"='INSTANCE' AND TO_NUMBER("FG"."INSTANCE_PK1_VALUE")=:B1 AND

                            NVL("FG"."END_DATE",SYSDATE@!+1)>=SYSDATE@! AND "FG"."START_DATE"<=SYSDATE@! AND "FG"."OBJECT_ID"="FO"."OBJECT_ID"))

              155 - access("FG"."GRANTEE_TYPE"='USER' AND "FG"."GRANTEE_KEY"="PA_SECURITY_PVT"."GET_GRANTEE_KEY"())

              156 - access(UPPER("HAOU"."NAME")=UPPER("XPD"."PROJECT_STATE"))

                     filter((UPPER("XPD"."PROJECT_MANAGER")=UPPER(:F_USER_NAME) OR UPPER("HAOU"."ATTRIBUTE1")=UPPER(:F_USER_NAME)))

              157 - access("BUDGET"."PROJECT_ID"="XPD"."PROJECT_ID")

              158 - filter("XPD"."PROJECT_ID"=:B1)

              160 - access("SUB_QUERY"."PROJECT_ID"=:B1 AND "SUB_QUERY"."END_DATE"=)

              161 - filter("CURRENT_PA_PERIOD_FLAG"='Y')

              162 - filter(UPPER("HAOU"."ATTRIBUTE2")='OPERATIONS')

               

              Column Projection Information (identified by operation id):

              -----------------------------------------------------------

               

                 1 - "DOM"[VARCHAR2,240]

                 2 - "DOM"[VARCHAR2,240]

                 3 - "XXDW_TASKS_DIM_T".ROWID[ROWID,10]

                 4 - "AID"."PROJECT_ID"[NUMBER,22]

                 5 - "AID".ROWID[ROWID,10]

                 6 - "XXDW_TASKS_DIM_T".ROWID[ROWID,10]

                 7 - "DOM"[VARCHAR2,240]

                 8 - "DOM"[VARCHAR2,240]

                 9 - "DOM"[VARCHAR2,240]

                10 - "XXDW_TASKS_DIM_T".ROWID[ROWID,10]

                11 - "POD"."PROJECT_ID"[NUMBER,22]

                12 - "AID"."PO_DISTRIBUTION_ID"[NUMBER,22]

                13 - "AID".ROWID[ROWID,10]

                14 - "POD"."PROJECT_ID"[NUMBER,22]

                15 - "POD".ROWID[ROWID,10]

                16 - "XXDW_TASKS_DIM_T".ROWID[ROWID,10]

                17 - "DOM"[VARCHAR2,240]

                18 - "PROJECT_MANAGER"[VARCHAR2,240]

                19 - "PROJECT_MANAGER"[VARCHAR2,240]

                20 - "XXDW_TASKS_DIM_T".ROWID[ROWID,10]

                21 - "AID"."PROJECT_ID"[NUMBER,22]

                22 - "AID".ROWID[ROWID,10]

                23 - "XXDW_TASKS_DIM_T".ROWID[ROWID,10]

                24 - "PROJECT_MANAGER"[VARCHAR2,240]

                25 - "PROJECT_MANAGER"[VARCHAR2,240]

                26 - "PROJECT_MANAGER"[VARCHAR2,240]

                27 - "XXDW_TASKS_DIM_T".ROWID[ROWID,10]

                28 - "POD"."PROJECT_ID"[NUMBER,22]

                29 - "AID"."PO_DISTRIBUTION_ID"[NUMBER,22]

                30 - "AID".ROWID[ROWID,10]

                31 - "POD"."PROJECT_ID"[NUMBER,22]

                32 - "POD".ROWID[ROWID,10]

                33 - "XXDW_TASKS_DIM_T".ROWID[ROWID,10]

                34 - "PROJECT_MANAGER"[VARCHAR2,240]

                35 - (#keys=3) :B1[30], INTERNAL_FUNCTION("PPP"."START_DATE_ACTIVE")[7], "PAPF"."FULL_NAME"[VARCHAR2,240], "PRT".ROWID[ROWID,10],

                     "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], ROWNUM[8], "PPP"."END_DATE_ACTIVE"[DATE,7],

                     "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7], "PAPF"."EFFECTIVE_END_DATE"[DATE,7],

                     FIRST_VALUE("PAPF"."FULL_NAME") OVER ( PARTITION BY :B2 ORDER BY INTERNAL_FUNCTION("PPP"."START_DATE_ACTIVE") DESC  RANGE  BETWEEN 

                     UNBOUNDED  PRECEDING  AND  CURRENT ROW )[240]

                36 - "PRT".ROWID[ROWID,10], "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10],

                     "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22],

                     "PPP"."START_DATE_ACTIVE"[DATE,7], "PPP"."END_DATE_ACTIVE"[DATE,7], "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22],

                     "PAPF"."EFFECTIVE_START_DATE"[DATE,7], "PAPF"."EFFECTIVE_END_DATE"[DATE,7], "PAPF"."FULL_NAME"[VARCHAR2,240], ROWNUM[8]

                37 - "PRT".ROWID[ROWID,10], "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10],

                     "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22],

                     "PPP"."START_DATE_ACTIVE"[DATE,7], "PPP"."END_DATE_ACTIVE"[DATE,7], "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22],

                     "PAPF"."EFFECTIVE_START_DATE"[DATE,7], "PAPF"."EFFECTIVE_END_DATE"[DATE,7], "PAPF"."FULL_NAME"[VARCHAR2,240]

                38 - "PRT".ROWID[ROWID,10], "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10],

                     "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22],

                     "PPP"."START_DATE_ACTIVE"[DATE,7], "PPP"."END_DATE_ACTIVE"[DATE,7], "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22],

                     "PAPF"."EFFECTIVE_START_DATE"[DATE,7], "PAPF"."EFFECTIVE_END_DATE"[DATE,7]

                39 - "PRT".ROWID[ROWID,10], "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10],

                     "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22],

                     "PPP"."START_DATE_ACTIVE"[DATE,7], "PPP"."END_DATE_ACTIVE"[DATE,7]

                40 - "PRT".ROWID[ROWID,10], "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80]

                41 - "PRT".ROWID[ROWID,10], "PRT"."MEANING"[VARCHAR2,80]

                42 - "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22],

                     "PPP"."START_DATE_ACTIVE"[DATE,7], "PPP"."END_DATE_ACTIVE"[DATE,7]

                43 - "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22]

                44 - "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7], "PAPF"."EFFECTIVE_END_DATE"[DATE,7]

                45 - "PAPF".ROWID[ROWID,10], "PAPF"."FULL_NAME"[VARCHAR2,240]

                46 - (#keys=3) :B1[30], INTERNAL_FUNCTION("PPP"."START_DATE_ACTIVE")[7], "PAPF"."FULL_NAME"[VARCHAR2,240],

                     "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], ROWNUM[8], "PPP"."END_DATE_ACTIVE"[DATE,7],

                     "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7], "PAPF"."EFFECTIVE_END_DATE"[DATE,7],

                     FIRST_VALUE("PAPF"."FULL_NAME") OVER ( PARTITION BY :B2 ORDER BY INTERNAL_FUNCTION("PPP"."START_DATE_ACTIVE") DESC  RANGE  BETWEEN 

                     UNBOUNDED  PRECEDING  AND  CURRENT ROW )[240]

                47 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], "PPP"."START_DATE_ACTIVE"[DATE,7],

                     "PPP"."END_DATE_ACTIVE"[DATE,7], "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7],

                     "PAPF"."EFFECTIVE_END_DATE"[DATE,7], "PAPF"."FULL_NAME"[VARCHAR2,240], ROWNUM[8]

                48 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], "PPP"."START_DATE_ACTIVE"[DATE,7],

                     "PPP"."END_DATE_ACTIVE"[DATE,7], "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7],

                     "PAPF"."EFFECTIVE_END_DATE"[DATE,7], "PAPF"."FULL_NAME"[VARCHAR2,240]

                49 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], "PPP"."START_DATE_ACTIVE"[DATE,7],

                     "PPP"."END_DATE_ACTIVE"[DATE,7], "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7],

                     "PAPF"."EFFECTIVE_END_DATE"[DATE,7]

                50 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], "PPP"."START_DATE_ACTIVE"[DATE,7],

                     "PPP"."END_DATE_ACTIVE"[DATE,7]

                51 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80]

                52 - "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22],

                     "PPP"."START_DATE_ACTIVE"[DATE,7], "PPP"."END_DATE_ACTIVE"[DATE,7]

                53 - "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22]

                54 - "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7], "PAPF"."EFFECTIVE_END_DATE"[DATE,7]

                55 - "PAPF".ROWID[ROWID,10], "PAPF"."FULL_NAME"[VARCHAR2,240]

                56 - (#keys=3) :B1[30], INTERNAL_FUNCTION("PPP"."START_DATE_ACTIVE")[7], "PAPF"."FULL_NAME"[VARCHAR2,240],

                     "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], ROWNUM[8], "PPP"."END_DATE_ACTIVE"[DATE,7],

                     "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7], "PAPF"."EFFECTIVE_END_DATE"[DATE,7],

                     FIRST_VALUE("PAPF"."FULL_NAME") OVER ( PARTITION BY :B2 ORDER BY INTERNAL_FUNCTION("PPP"."START_DATE_ACTIVE") DESC  RANGE  BETWEEN 

                     UNBOUNDED  PRECEDING  AND  CURRENT ROW )[240]

                57 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], "PPP"."START_DATE_ACTIVE"[DATE,7],

                     "PPP"."END_DATE_ACTIVE"[DATE,7], "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7],

                     "PAPF"."EFFECTIVE_END_DATE"[DATE,7], "PAPF"."FULL_NAME"[VARCHAR2,240], ROWNUM[8]

                58 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], "PPP"."START_DATE_ACTIVE"[DATE,7],

                     "PPP"."END_DATE_ACTIVE"[DATE,7], "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7],

                     "PAPF"."EFFECTIVE_END_DATE"[DATE,7], "PAPF"."FULL_NAME"[VARCHAR2,240]

                59 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], "PPP"."START_DATE_ACTIVE"[DATE,7],

                     "PPP"."END_DATE_ACTIVE"[DATE,7], "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7],

                     "PAPF"."EFFECTIVE_END_DATE"[DATE,7]

                60 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80], "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22],

                     "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22], "PPP"."START_DATE_ACTIVE"[DATE,7],

                     "PPP"."END_DATE_ACTIVE"[DATE,7]

                61 - "PRT"."PROJECT_ROLE_ID"[NUMBER,22], "PRT"."MEANING"[VARCHAR2,80]

                62 - "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."RESOURCE_SOURCE_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22],

                     "PPP"."START_DATE_ACTIVE"[DATE,7], "PPP"."END_DATE_ACTIVE"[DATE,7]

                63 - "PPP".ROWID[ROWID,10], "PPP"."PROJECT_ID"[NUMBER,22], "PPP"."PROJECT_ROLE_ID"[NUMBER,22]

                64 - "PAPF".ROWID[ROWID,10], "PAPF"."PERSON_ID"[NUMBER,22], "PAPF"."EFFECTIVE_START_DATE"[DATE,7], "PAPF"."EFFECTIVE_END_DATE"[DATE,7]

                65 - "PAPF".ROWID[ROWID,10], "PAPF"."FULL_NAME"[VARCHAR2,240]

                66 - (#keys=0) MIN(LEAST(NVL("DISCOUNT_DATE","DUE_DATE"),"DUE_DATE"))[7]

                67 - "DISCOUNT_DATE"[DATE,7], "DUE_DATE"[DATE,7]

                68 - "APS".ROWID[ROWID,10]

                69 - (#keys=0) MIN(LEAST(NVL("DISCOUNT_DATE","DUE_DATE"),"DUE_DATE"))[7]

                70 - "DISCOUNT_DATE"[DATE,7], "DUE_DATE"[DATE,7]

                71 - "APS".ROWID[ROWID,10]

                72 - "LINE_NUM"[NUMBER,22]

                73 - "PLL"."PO_LINE_ID"[NUMBER,22]

                74 - "PLL".ROWID[ROWID,10]

                75 - "LINE_NUM"[NUMBER,22]

                76 - "PL".ROWID[ROWID,10]

                77 - "SEQ_NO"[NUMBER,22]

                78 - "PLL"."ATTRIBUTE15"[VARCHAR2,150]

                79 - "PLL".ROWID[ROWID,10]

                80 - "SEQ_NO"[NUMBER,22]

                81 - "XBL".ROWID[ROWID,10]

                82 - "AP_EMP"."FULL_NAME"[VARCHAR2,240]

                83 - "AP_EMP".ROWID[ROWID,10]

                84 - (#keys=28) NVL(,)[240], "PPA"."PROJECT_NAME"[VARCHAR2,30], "PPA"."PROJECT_NUMBER"[VARCHAR2,25],

                     "PPA"."PROJECT_EXECUTIVE"[VARCHAR2,240], "PPA"."PROJECT_ENGINEER"[VARCHAR2,240], NVL(,)[240], "PPA"."APM"[VARCHAR2,240],

                     "PAV"."VENDOR_NAME"[VARCHAR2,240], "PAV"."VENDOR_TYPE_LOOKUP_CODE"[VARCHAR2,30], "AI"."INVOICE_NUM"[VARCHAR2,50],

                     "AI"."INVOICE_ID"[NUMBER,22], [7], CASE  WHEN (SYSDATE@!>-7 AND SYSDATE@!<) THEN '<span

                     style="background-color:#FFFF99;">'||TO_CHAR(,:DATE_FORMAT)||'</span>' WHEN SYSDATE@!> THEN '<span

                     style="background-color:#FF7755;">'||TO_CHAR(,:DATE_FORMAT)||'</span>' ELSE TO_CHAR(,:DATE_FORMAT) END [122],

                     "AI"."INVOICE_DATE"[DATE,7], "AI"."INVOICE_AMOUNT"[NUMBER,22], "AI"."DESCRIPTION"[VARCHAR2,240],

                     "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25], "XXPDI_OBIEE_PKG"."GET_PO_NUMBER"("AI"."INVOICE_NUM","PAV"."VENDOR_NAME")[4000], [22],

                     "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."HOLD_DATE"[DATE,7], "COMM_INFO"."LAST_COMMENT_DATE"[DATE,7],

                     "APEX_ITEM"."HIDDEN"(1,TO_CHAR("AH"."HOLD_ID"))||"XXEXT_AP_INV_APEX_WRP"."FUNC_SHOW_COMMENTS"("AH"."HOLD_ID","XXEXT_AP_INV_APEX_WRP"."IS_A

                     P_VIEW"(:APP_USER),0,'AP',NULL,100)||'<div class="btnWrapper">'||'<a id="addComments_'||TO_CHAR("AH"."HOLD_ID")||'" class="btn_add"

                     onclick="return false;" href="f?p='||:APP_ID||':11:'||:APP_SESSION||':::11:P11_HOLD_ID,P11_WAITING_ON,P11_COMMENT_TYPE:'||TO_CHAR("AH"."HO

                     LD_ID")||','||CASE TO_NUMBER(:F_IS_AP) WHEN 1 THEN 'PM' ELSE 'AP' END ||','||CASE  WHEN (TO_NUMBER(:F_IS_AP)=1) THEN 'AP' WHEN

                     (TO_NUMBER(:F_IS_LPM)=1) THEN 'LPM' ELSE 'PM' END ||'"><button type="button" class="button-default" '||' onclick="return false;" >

                     '||'<span>Add Comment</span></button></a>'||CASE  WHEN (NVL("COMM_INFO"."NB_COMMENTS",0)>0) THEN ('<a

                     id="addShowAll_'||TO_CHAR("AH"."HOLD_ID")||'" class="btn_showall" onclick="return false;"

                     href="f?p='||:APP_ID||':12:'||:APP_SESSION||':::12:P12_HOLD_ID,P12_PROV_VIEW:'||TO_CHAR("AH"."HOLD_ID")||',AP'||'"><button type="button"

                     class="button-default" '||' onclick="return false;" > '||'<span>Show All '||CASE  WHEN ("COMM_INFO"."NB_COMMENTS">0) THEN

                     ('('||TO_CHAR("COMM_INFO"."NB_COMMENTS")||')') END ||'</span></button></a>') END ||'</div>'[4000],

                     "XXEXT_AP_INV_APEX_WRP"."FUNC_SHOW_COMMENTS"("AH"."HOLD_ID","XXEXT_AP_INV_APEX_WRP"."IS_AP_VIEW"(:APP_USER),0,'AP',1)[4000], CASE

                     TO_NUMBER(:F_IS_AP) WHEN 1 THEN "APEX_ITEM"."SELECT_LIST"(1,NVL("AC"."HOLD_VALUE",NVL("AH"."ATTRIBUTE3",'Waiting on AP')),'AP;Waiting on

                     AP,PM;Waiting on PM',' class="holds-waiting-on holds-item-field waitingon-'||NVL("AC"."HOLD_VALUE",TRIM(REPLACE(UPPER(NVL("AH"."ATTRIBUTE3

                     ",'Waiting on AP')),'WAITING ON','')))||'" '||' data-seq_id="'||TO_CHAR("AC"."SEQ_ID")||'" '||'

                     data-hold_id="'||TO_CHAR("AH"."HOLD_ID")||'" '||' data-attr_number="1" ','NO') ELSE TRIM(REPLACE(UPPER(NVL("AH"."ATTRIBUTE3",'Waiting on

                     AP')),'WAITING ON','')) END [4000], CASE  WHEN "XXPDI_OBIEE_PKG"."GET_PO_NUMBER"("AI"."INVOICE_NUM","PAV"."VENDOR_NAME")='None' THEN

                     'None' ELSE TO_CHAR("XXPDI_OBIEE_PKG"."GET_CBOM_NUMBER"("XXPDI_OBIEE_PKG"."GET_PO_NUMBER"("AI"."INVOICE_NUM","PAV"."VENDOR_NAME"))) END

                     [40], [22], [240]

                85 - "AI"."INVOICE_ID"[NUMBER,22], "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22],

                     "AC"."HOLD_VALUE"[VARCHAR2,4000], "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240],

                     "COMM_INFO"."NB_COMMENTS"[NUMBER,22], "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25], "AI"."INVOICE_NUM"[VARCHAR2,50],

                     "AI"."INVOICE_AMOUNT"[NUMBER,22], "AI"."INVOICE_DATE"[DATE,7], "AI"."DESCRIPTION"[VARCHAR2,240], "PAV"."VENDOR_NAME"[VARCHAR2,240],

                     "PAV"."VENDOR_TYPE_LOOKUP_CODE"[VARCHAR2,30], "PAV"."ATTRIBUTE1"[VARCHAR2,150], "COMM_INFO"."LAST_COMMENT_DATE"[DATE,7],

                     "PPA"."PROJECT_NAME"[VARCHAR2,30], "PPA"."PROJECT_NUMBER"[VARCHAR2,25], "PPA"."APM"[VARCHAR2,240],

                     "PPA"."PROJECT_EXECUTIVE"[VARCHAR2,240], "PPA"."PROJECT_ENGINEER"[VARCHAR2,240]

                86 - (#keys=1) "AI"."INVOICE_ID"[NUMBER,22], "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22],

                     "AC"."HOLD_VALUE"[VARCHAR2,4000], "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240],

                     "AH"."INVOICE_ID"[NUMBER,22], "AH"."HOLD_REASON"[VARCHAR2,240], "COMM_INFO"."NB_COMMENTS"[NUMBER,22],

                     "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25], "AI"."INVOICE_NUM"[VARCHAR2,50], "AI"."INVOICE_AMOUNT"[NUMBER,22],

                     "AI"."INVOICE_DATE"[DATE,7], "AI"."DESCRIPTION"[VARCHAR2,240], "PAV"."VENDOR_NAME"[VARCHAR2,240],

                     "PAV"."VENDOR_TYPE_LOOKUP_CODE"[VARCHAR2,30], "PAV"."ATTRIBUTE1"[VARCHAR2,150], "COMM_INFO"."LAST_COMMENT_DATE"[DATE,7],

                     "PPA"."PROJECT_NAME"[VARCHAR2,30], "PPA"."PROJECT_NUMBER"[VARCHAR2,25], "PPA"."PROJECT_ID"[NUMBER,22], "PPA"."APM"[VARCHAR2,240],

                     "PPA"."PROJECT_EXECUTIVE"[VARCHAR2,240], "PPA"."PROJECT_ENGINEER"[VARCHAR2,240]

                87 - "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000],

                     "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."INVOICE_ID"[NUMBER,22],

                     "AH"."HOLD_REASON"[VARCHAR2,240], "AI"."INVOICE_ID"[NUMBER,22], "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25],

                     "AI"."INVOICE_NUM"[VARCHAR2,50], "AI"."INVOICE_AMOUNT"[NUMBER,22], "AI"."INVOICE_DATE"[DATE,7], "AI"."DESCRIPTION"[VARCHAR2,240],

                     "PAV"."VENDOR_NAME"[VARCHAR2,240], "PAV"."VENDOR_TYPE_LOOKUP_CODE"[VARCHAR2,30], "PAV"."ATTRIBUTE1"[VARCHAR2,150],

                     "COMM_INFO"."LAST_COMMENT_DATE"[DATE,7], "COMM_INFO"."NB_COMMENTS"[NUMBER,22]

                88 - (#keys=1) "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000],

                     "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."INVOICE_ID"[NUMBER,22],

                     "AH"."HOLD_REASON"[VARCHAR2,240], "AI"."INVOICE_ID"[NUMBER,22], "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25],

                     "AI"."INVOICE_NUM"[VARCHAR2,50], "AI"."INVOICE_AMOUNT"[NUMBER,22], "AI"."INVOICE_DATE"[DATE,7], "AI"."DESCRIPTION"[VARCHAR2,240],

                     "PAV"."VENDOR_NAME"[VARCHAR2,240], "PAV"."VENDOR_TYPE_LOOKUP_CODE"[VARCHAR2,30], "PAV"."ATTRIBUTE1"[VARCHAR2,150],

                     "COMM_INFO"."LAST_COMMENT_DATE"[DATE,7], "COMM_INFO"."NB_COMMENTS"[NUMBER,22]

                89 - "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000],

                     "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."INVOICE_ID"[NUMBER,22],

                     "AH"."HOLD_REASON"[VARCHAR2,240], "AI"."INVOICE_ID"[NUMBER,22], "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25],

                     "AI"."INVOICE_NUM"[VARCHAR2,50], "AI"."INVOICE_AMOUNT"[NUMBER,22], "AI"."INVOICE_DATE"[DATE,7], "AI"."DESCRIPTION"[VARCHAR2,240],

                     "PAV"."VENDOR_NAME"[VARCHAR2,240], "PAV"."VENDOR_TYPE_LOOKUP_CODE"[VARCHAR2,30], "PAV"."ATTRIBUTE1"[VARCHAR2,150]

                90 - "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000],

                     "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."INVOICE_ID"[NUMBER,22],

                     "AH"."HOLD_REASON"[VARCHAR2,240], "AI"."INVOICE_ID"[NUMBER,22], "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25],

                     "AI"."INVOICE_NUM"[VARCHAR2,50], "AI"."INVOICE_AMOUNT"[NUMBER,22], "AI"."INVOICE_DATE"[DATE,7], "AI"."DESCRIPTION"[VARCHAR2,240],

                     "PAV"."VENDOR_NAME"[VARCHAR2,240], "PAV"."VENDOR_TYPE_LOOKUP_CODE"[VARCHAR2,30], "PAV"."ATTRIBUTE1"[VARCHAR2,150]

                91 - (#keys=1) "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000],

                     "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."INVOICE_ID"[NUMBER,22],

                     "AH"."HOLD_REASON"[VARCHAR2,240], "AI"."INVOICE_ID"[NUMBER,22], "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25],

                     "AI"."INVOICE_NUM"[VARCHAR2,50], "AI"."INVOICE_AMOUNT"[NUMBER,22], "AI"."INVOICE_DATE"[DATE,7], "AI"."DESCRIPTION"[VARCHAR2,240],

                     "PAV"."PARTY_ID"[NUMBER,22], "PAV"."VENDOR_NAME"[VARCHAR2,240], "PAV"."VENDOR_TYPE_LOOKUP_CODE"[VARCHAR2,30],

                     "PAV"."ATTRIBUTE1"[VARCHAR2,150]

                92 - "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000],

                     "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."INVOICE_ID"[NUMBER,22],

                     "AH"."HOLD_REASON"[VARCHAR2,240], "AI"."INVOICE_ID"[NUMBER,22], "AI"."VENDOR_ID"[NUMBER,22], "AI"."INVOICE_NUM"[VARCHAR2,50],

                     "AI"."INVOICE_AMOUNT"[NUMBER,22], "AI"."INVOICE_DATE"[DATE,7], "AI"."DESCRIPTION"[VARCHAR2,240], "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25]

                93 - "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000],

                     "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."INVOICE_ID"[NUMBER,22],

                     "AH"."HOLD_REASON"[VARCHAR2,240], "AI".ROWID[ROWID,10], "AI"."INVOICE_ID"[NUMBER,22]

                94 - (#keys=1) "AH"."HOLD_ID"[NUMBER,22], "AH"."ATTRIBUTE3"[VARCHAR2,150], "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000],

                     "AH"."INVOICE_ID"[NUMBER,22], "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240],

                     "AH"."INVOICE_ID"[NUMBER,22], "AH"."HOLD_REASON"[VARCHAR2,240]

                95 - (#keys=1) "AH"."HOLD_ID"[NUMBER,22], "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000], "AH"."INVOICE_ID"[NUMBER,22],

                     "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."ATTRIBUTE3"[VARCHAR2,150]

                96 - "AC"."SEQ_ID"[NUMBER,22], "AC"."HOLD_ID"[NUMBER,22], "AC"."HOLD_VALUE"[VARCHAR2,4000]

                97 - "M"."SEQ_ID"[NUMBER,22], "M"."C001"[VARCHAR2,4000], "M"."N001"[NUMBER,22]

                98 - "M".ROWID[ROWID,10], "M"."SEQ_ID"[NUMBER,22]

                99 - "C"."ID"[NUMBER,22]

              102 - "SGID"."SECURITY_GROUP_ID"[NUMBER,22]

              103 - VALUE(A0)[32767], ROWNUM[8]

              104 - VALUE(A0)[32767]

              105 - "C"."ID"[NUMBER,22]

              106 - "C".ROWID[ROWID,10]

              109 - "M".ROWID[ROWID,10], "M"."SEQ_ID"[NUMBER,22]

              110 - "M"."C001"[VARCHAR2,4000], "M"."N001"[NUMBER,22]

              111 - "AH"."INVOICE_ID"[NUMBER,22], "AH"."LINE_LOCATION_ID"[NUMBER,22], "AH"."HOLD_DATE"[DATE,7], "AH"."HOLD_REASON"[VARCHAR2,240],

                     "AH"."ATTRIBUTE3"[VARCHAR2,150], "AH"."HOLD_ID"[NUMBER,22]

              112 - "AH".ROWID[ROWID,10], "AH"."INVOICE_ID"[NUMBER,22]

              113 - (rowset=200) "AH"."INVOICE_ID"[NUMBER,22], "AH"."HOLD_REASON"[VARCHAR2,240], "AH"."HOLD_ID"[NUMBER,22]

              114 - "AI".ROWID[ROWID,10], "AI"."INVOICE_ID"[NUMBER,22]

              115 - "AI"."VENDOR_ID"[NUMBER,22], "AI"."INVOICE_NUM"[VARCHAR2,50], "AI"."INVOICE_AMOUNT"[NUMBER,22], "AI"."INVOICE_DATE"[DATE,7],

                     "AI"."DESCRIPTION"[VARCHAR2,240], "AI"."PAY_GROUP_LOOKUP_CODE"[VARCHAR2,25]

              116 - (rowset=200) "PAV"."VENDOR_ID"[NUMBER,22], "PAV"."VENDOR_NAME"[VARCHAR2,240], "PAV"."VENDOR_TYPE_LOOKUP_CODE"[VARCHAR2,30],

                     "PAV"."ATTRIBUTE1"[VARCHAR2,150], "PAV"."PARTY_ID"[NUMBER,22]

              118 - "COMM_INFO"."HOLD_ID"[NUMBER,22], "COMM_INFO"."NB_COMMENTS"[NUMBER,22], "COMM_INFO"."LAST_COMMENT_DATE"[DATE,7]

              119 - "HOLD_ID"[NUMBER,22], COUNT(*)[22], MAX("CREATION_DATE")[7]

              120 - (rowset=200) "HOLD_ID"[NUMBER,22], "CREATION_DATE"[DATE,7]

              121 - (rowset=200) "HOLD_ID"[NUMBER,22], "CREATION_DATE"[DATE,7]

              122 - "PPA"."PROJECT_NAME"[VARCHAR2,30], "PPA"."PROJECT_NUMBER"[VARCHAR2,25], "PPA"."PROJECT_ID"[NUMBER,22],

                     "PPA"."INVOICE_ID"[NUMBER,22], "PPA"."PROJECT_EXECUTIVE"[VARCHAR2,240], "PPA"."PROJECT_ENGINEER"[VARCHAR2,240], "PPA"."APM"[VARCHAR2,240]

              123 - "PPA"."NAME"[VARCHAR2,30], "PPA"."SEGMENT1"[VARCHAR2,25], "PPA"."PROJECT_ID"[NUMBER,22], "AID"."INVOICE_ID"[NUMBER,22], [240],

                     [240], [240]

              124 - "PPA"."PROJECT_ID"[NUMBER,22], "PPA"."SEGMENT1"[VARCHAR2,25], "PPA"."NAME"[VARCHAR2,30], "AID"."INVOICE_ID"[NUMBER,22]

              125 - "PPA"."PROJECT_ID"[NUMBER,22], "PPA"."SEGMENT1"[VARCHAR2,25], "PPA"."NAME"[VARCHAR2,30], "AID"."INVOICE_ID"[NUMBER,22],

                     "AID"."INVOICE_LINE_NUMBER"[NUMBER,22]

              126 - (#keys=1) "PPA"."PROJECT_ID"[NUMBER,22], "PPA"."SEGMENT1"[VARCHAR2,25], "PPA"."NAME"[VARCHAR2,30], "AID"."INVOICE_ID"[NUMBER,22],

                     "AID"."INVOICE_LINE_NUMBER"[NUMBER,22]

              127 - (rowset=200) "PPA"."PROJECT_ID"[NUMBER,22], "PPA"."NAME"[VARCHAR2,30], "PPA"."SEGMENT1"[VARCHAR2,25]

              128 - (#keys=1) "POD"."PROJECT_ID"[NUMBER,22], "AID"."INVOICE_ID"[NUMBER,22], "AID"."INVOICE_LINE_NUMBER"[NUMBER,22],

                     "AID"."PROJECT_ID"[NUMBER,22]

              129 - "POD"."PO_DISTRIBUTION_ID"[NUMBER,22], "POD"."PROJECT_ID"[NUMBER,22]

              130 - "AID"."INVOICE_ID"[NUMBER,22], "AID"."PO_DISTRIBUTION_ID"[NUMBER,22], "AID"."PROJECT_ID"[NUMBER,22],

                     "AID"."INVOICE_LINE_NUMBER"[NUMBER,22]

              132 - "AIL".ROWID[ROWID,10]

              134 - "AHA".ROWID[ROWID,10]

              136 - "AH1".ROWID[ROWID,10]

              138 - "AH1".ROWID[ROWID,10]

              139 - (#keys=1) STRDEF[22]

              140 - STRDEF[22]

              141 - "PPA"."PROJECT_ID"[NUMBER,22]

              142 - "USER_ID"[NUMBER,22], "EMPLOYEE_ID"[NUMBER,22], "PPA"."PROJECT_ID"[NUMBER,22], "PPA"."CARRYING_OUT_ORGANIZATION_ID"[NUMBER,22]

              143 - "USER_ID"[NUMBER,22], "EMPLOYEE_ID"[NUMBER,22], "PPA"."PROJECT_ID"[NUMBER,22], "PPA"."CARRYING_OUT_ORGANIZATION_ID"[NUMBER,22]

              144 - "USER_ID"[NUMBER,22], "EMPLOYEE_ID"[NUMBER,22]

              145 - "FND_USER".ROWID[ROWID,10], "USER_ID"[NUMBER,22]

              146 - "PPA"."PROJECT_ID"[NUMBER,22], "PPA"."CARRYING_OUT_ORGANIZATION_ID"[NUMBER,22]

              147 - "PPA".ROWID[ROWID,10], "PPA"."PROJECT_ID"[NUMBER,22]

              150 - "PA_PROJECT_PARTIES".ROWID[ROWID,10]

              152 - "FO"."OBJECT_ID"[NUMBER,22]

              153 - "FO".ROWID[ROWID,10]

              155 - "FG".ROWID[ROWID,10]

              156 - (#keys=1) "XPD"."PROJECT_ID"[NUMBER,22]

              157 - (#keys=1) "XPD"."PROJECT_ID"[NUMBER,22], "XPD"."PROJECT_STATE"[VARCHAR2,120], "XPD"."PROJECT_MANAGER"[VARCHAR2,240]

              158 - "XPD"."PROJECT_ID"[NUMBER,22], "XPD"."PROJECT_MANAGER"[VARCHAR2,240], "XPD"."PROJECT_STATE"[VARCHAR2,120]

              159 - "BUDGET"."PROJECT_ID"[NUMBER,22]

              160 - "SUB_QUERY"."PROJECT_ID"[NUMBER,22]

              161 - "END_DATE"[DATE,7]

              162 - "HAOU"."NAME"[VARCHAR2,240], "HAOU"."ATTRIBUTE1"[VARCHAR2,150]

               

              Note

              -----

                 - dynamic statistics used: dynamic sampling (level=2)

                 - 9 Sql Plan Directives used for this statement

               

              ----------------------------------------------------------------------------

               

              Do point out if I should add anything further or if I left out relevant detail.

              • 4. Re: APEX page load performance
                Flammifer

                UPDATE: Web server is APEX listener ORDS integrated with Glassfish, for more complete details.