SELECT PEA.INCURRED_BY_PERSON_ID AS PERSON_ID,
          PEA.EXPENDITURE_ENDING_DATE AS WEEK_END_DATE,
          CASE
             WHEN (PEIA.PROJECT_ID IN (496, 497, 499, 502, 507)
                   OR (PEIA.PROJECT_ID = 7290
                       AND PEIA.TASK_ID IN
                              (187096,
                               187097,
                               187098,
                               187099,
                               187100,
                               187101,
                               187102,
                               187103,
                               187104,
                               187105)))
             THEN
                'V'
             ELSE
                PEIA.BILLABLE_FLAG
          END
             AS BILLABLE_FLAG,
          NVL (PEIA.QUANTITY, 0) AS QUANTITY,
          NVL (PEIA.TRANSACTION_SOURCE, 'EXPENDITURE BATCH')
             AS TRANSACTION_SOURCE
     FROM PA_EXPENDITURE_ITEMS_ALL PEIA
          INNER JOIN (SELECT *
                        FROM PA_EXPENDITURES_ALL
                       WHERE EXPENDITURE_ENDING_DATE > to_date( '29-MAR-2009', 'DD-MON-YYYY')) PEA
             ON PEIA.EXPENDITURE_ID = PEA.EXPENDITURE_ID
    WHERE PEIA.SYSTEM_LINKAGE_FUNCTION = 'ST';

SELECT STATEMENT  ALL_ROWSCost: 48,287  Bytes: 18,428,818  Cardinality: 297,239  		
	3 HASH JOIN  Cost: 48,287  Bytes: 18,428,818  Cardinality: 297,239  	
		1 TABLE ACCESS FULL TABLE PA.PA_EXPENDITURES_ALL Cost: 2,964  Bytes: 3,506,094  Cardinality: 194,783  
		2 TABLE ACCESS FULL TABLE PA.PA_EXPENDITURE_ITEMS_ALL Cost: 43,425  Bytes: 26,637,468  Cardinality: 605,397  

SQL> explain plan for select 1 from dual;

Explained.

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 1546270724

-----------------------------------------------------------------
| Id  | Operation        | Name | Rows  | Cost (%CPU)| Time     |
-----------------------------------------------------------------
|   0 | SELECT STATEMENT |      |     1 |     2   (0)| 00:00:01 |
|   1 |  FAST DUAL       |      |     1 |     2   (0)| 00:00:01 |
-----------------------------------------------------------------

8 rows selected.

SQL> 

INDEX_NAME	         COLUMN
PA_EXPENDITURE_ITEMS_ALL_N27	PROJECT_ID
PA_EXPENDITURE_ITEMS_N2	        TASK_ID
PA_EXPENDITURE_ITEMS_N2	        BILL_HOLD_FLAG
PA_EXPENDITURE_ITEMS_N2	        PROJECT_ID
PA_EXPENDITURE_ITEMS_N25	TASK_ID
PA_EXPENDITURE_ITEMS_N25	COST_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N25	SYSTEM_LINKAGE_FUNCTION
PA_EXPENDITURES_ITEMS_N18	BURDEN_SUM_DEST_RUN_ID
PA_EXPENDITURE_ITEMS_N1	        EXPENDITURE_ID
PA_EXPENDITURE_ITEMS_N1	        EXPENDITURE_ITEM_DATE
PA_EXPENDITURE_ITEMS_N10	TRANSACTION_SOURCE
PA_EXPENDITURE_ITEMS_N10	ORIG_TRANSACTION_REFERENCE
PA_EXPENDITURE_ITEMS_N12	REV_IND_COMPILED_SET_ID
PA_EXPENDITURE_ITEMS_N13	INV_IND_COMPILED_SET_ID
PA_EXPENDITURE_ITEMS_N14	SOURCE_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_N16	REQUEST_ID
PA_EXPENDITURE_ITEMS_N16	COST_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N17	TASK_ID
PA_EXPENDITURE_ITEMS_N17	REVENUE_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N18	EXPENDITURE_TYPE
PA_EXPENDITURE_ITEMS_N18	SYSTEM_LINKAGE_FUNCTION
PA_EXPENDITURE_ITEMS_N19	DENORM_ID
PA_EXPENDITURE_ITEMS_ALL_N27	ADJUSTMENT_TYPE
PA_EXPENDITURE_ITEMS_N9	        TASK_ID
PA_EXPENDITURE_ITEMS_N9	        EXPENDITURE_ITEM_DATE
PA_EXPENDITURE_ITEMS_N20	CC_BL_DISTRIBUTED_CODE
PA_EXPENDITURE_ITEMS_N21	CC_CROSS_CHARGE_CODE
PA_EXPENDITURE_ITEMS_N22	RECVR_ORG_ID
PA_EXPENDITURE_ITEMS_N22	CC_IC_PROCESSED_CODE
PA_EXPENDITURE_ITEMS_N22	CC_CROSS_CHARGE_CODE
PA_EXPENDITURE_ITEMS_N22	EXPENDITURE_ITEM_DATE
PA_EXPENDITURE_ITEMS_N22	TASK_ID
PA_EXPENDITURE_ITEMS_N23	TP_IND_COMPILED_SET_ID
PA_EXPENDITURE_ITEMS_N3	        COST_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N4	        REVENUE_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N5	        ADJUSTED_EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_N6	        TRANSFERRED_FROM_EXP_ITEM_ID
PA_EXPENDITURE_ITEMS_N7	        REQUEST_ID
PA_EXPENDITURE_ITEMS_N7	        REVENUE_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_U1	        EXPENDITURE_ITEM_ID
PA_EXPENDITURE_ITEMS_N11	COST_IND_COMPILED_SET_ID
PA_EXPENDITURE_ITEMS_N15	COST_BURDEN_DISTRIBUTED_FLAG
PA_EXPENDITURE_ITEMS_N8	        PROJECT_ID
PA_EXPENDITURE_ITEMS_N8	        EVENT_NUM
PA_EXPENDITURE_ITEMS_N8	        EVENT_TASK_ID
PA_EXPENDITURE_ITEMS_N24	EXPENDITURE_ITEM_DATE

INDEX_NAME	    COLUMN
PA_EXPENDITURES_ALL_N9	EXPENDITURE_GROUP
PA_EXPENDITURES_ALL_N9	INCURRED_BY_ORGANIZATION_ID
PA_EXPENDITURES_N8	TRANSFER_STATUS_CODE
PA_EXPENDITURES_N1	INCURRED_BY_PERSON_ID
PA_EXPENDITURES_N1	EXPENDITURE_ENDING_DATE
PA_EXPENDITURES_N2	INCURRED_BY_ORGANIZATION_ID
PA_EXPENDITURES_N3	EXPENDITURE_GROUP
PA_EXPENDITURES_N4	EXPENDITURE_STATUS_CODE
PA_EXPENDITURES_N5	ENTERED_BY_PERSON_ID
PA_EXPENDITURES_N6	REQUEST_ID
PA_EXPENDITURES_N7	ATTRIBUTE1
PA_EXPENDITURES_U1	EXPENDITURE_ID