SELECT amount_type_code, drilldown_key1, OP.name, sort_order, OP.org_id, actual_ptd, budget_ptd, actual_ytd, budget_ytd FROM PA_BIS_TO_DATE_DRILLS PA, PA_ORGANIZATIONS_PROJ_ALL_BG_V OP WHERE PA.drilldown_type='ORGANIZATION' AND PA.drilldown_key1=OP.organization_id AND NVL(pa.org_id,-99)=NVL(op.org_id,-99)
SELECT AMOUNT_TYPE_CODE
, DRILLDOWN_KEY1
, OP.NAME
, SORT_ORDER
, OP.ORG_ID
, ACTUAL_PTD
, BUDGET_PTD
, ACTUAL_YTD
, BUDGET_YTD
FROM PA_BIS_TO_DATE_DRILLS PA
, PA_ORGANIZATIONS_PROJ_ALL_BG_V OP
WHERE PA.DRILLDOWN_TYPE='ORGANIZATION'
AND PA.DRILLDOWN_KEY1=OP.ORGANIZATION_ID
AND NVL(PA.ORG_ID
, -99)=NVL(OP.ORG_ID
, -99)
|
|
|