View: PA_CC_BL_CUR_SEL_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CC_BL_CUR_SEL_V

View Text

SELECT ROWIDTOCHAR(EI.ROWID) EXP_ITEM_ROWID
, EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, T.PROJECT_ID PROJECT_ID
, DECODE(EI.CC_CROSS_CHARGE_CODE
, 'B'
, DECODE(ADJUSTED_EXPENDITURE_ITEM_ID
, NULL
, 'Y'
, 'N')
, 'N') CALC_TP_FLAG
, EI.ADJUSTED_EXPENDITURE_ITEM_ID ADJUSTED_EXP_ITEM_ID
, EI.SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, EI.TASK_ID TASK_ID
, EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EI.NET_ZERO_ADJUSTMENT_FLAG NET_ZERO_FLAG
, EI.QUANTITY QUANTITY
, EI.BILLABLE_FLAG BILLABLE_FLAG
, EI.ORGANIZATION_ID NL_RESOURCE_ORGANIZATION_ID
, NLORG.NAME NL_ORGANIZATION_NAME
, EI.CC_PRVDR_ORGANIZATION_ID PRVDR_ORGANIZATION_ID
, EI.CC_RECVR_ORGANIZATION_ID RECVR_ORGANIZATION_ID
, EI.DENOM_TP_CURRENCY_CODE DENOM_TP_CURRENCY_CODE
, EI.DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, EI.DENOM_TRANSFER_PRICE DENOM_TRANSFER_PRICE
, EI.ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, EI.ACCT_TP_RATE_TYPE ACCT_TP_RATE_TYPE
, EI.ACCT_TP_RATE_DATE ACCT_TP_RATE_DATE
, EI.ACCT_TP_EXCHANGE_RATE ACCT_TP_EXCHANGE_RATE
, EI.ACCT_TRANSFER_PRICE ACCT_TRANSFER_PRICE
, EI.PROJECT_CURRENCY_CODE PROJ_CURRENCY_CODE
, EI.CC_CROSS_CHARGE_CODE CROSS_CHARGE_CODE
, EI.EXPENDITURE_TYPE EXPENDITURE_TYPE
, EI.REVENUE_DISTRIBUTED_FLAG REVENUE_DISTRIBUTED_FLAG
, EI.JOB_ID JOB_ID
, EXP.EXPENDITURE_GROUP EXPENDITURE_GROUP
, EXP.EXPENDITURE_ENDING_DATE EXPENDITURE_ENDING_DATE
, PA_UTILS.GET_PA_DATE(EI.EXPENDITURE_ITEM_DATE
, SYSDATE) PA_DATE
, DECODE(EI.OVERRIDE_TO_ORGANIZATION_ID
, NULL
, EXP.INCURRED_BY_ORGANIZATION_ID) EXPENDITURE_ORGANIZATION_ID
, EXPORG.NAME EXPENDITURE_ORGANIZATION_NAME
, T.CARRYING_OUT_ORGANIZATION_ID TASK_ORGANIZATION_ID
, T.TASK_NUMBER TASK_NUMBER
, ET.REVENUE_CATEGORY_CODE REVENUE_CATEGORY
, ET.EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, EI.NON_LABOR_RESOURCE NON_LABOR_RESOURCE
, PROJORG.ORGANIZATION_ID PROJ_ORGANIZATION_ID
, PROJORG.NAME PROJ_ORGANIZATION_NAME
, TASKORG.NAME TASK_ORGANIZATION_NAME
, T.SERVICE_TYPE_CODE TASK_SERVICE_TYPE
, P.PROJECT_TYPE PROJECT_TYPE
, P.SEGMENT1 PROJECT_NUMBER
, PRVORG.NAME PRVDR_ORGANIZATION_NAME
, RCVORG.NAME RECVR_ORGANIZATION_NAME
, P.ORG_ID RECVR_ORG_ID
, RCVOU.NAME RECVR_ORG_NAME
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PER.PERSON_ID PERSON_ID
, DECODE( SYS.LABOR_NON_LABOR_FLAG
, 'Y'
, T.LABOR_TP_SCHEDULE_ID
, T.NL_TP_SCHEDULE_ID) TP_SCHEDULE_ID
, DECODE( SYS.LABOR_NON_LABOR_FLAG
, 'Y'
, T.LABOR_TP_FIXED_DATE
, T.NL_TP_FIXED_DATE) TP_FIXED_DATE
, EI.TP_IND_COMPILED_SET_ID TP_IND_COMPILED_SET_ID
, EI.TP_BILL_RATE TP_BILL_RATE
, EI.TP_BILL_MARKUP_PERCENTAGE TP_BILL_MARKUP_PERCENTAGE
, EI.TP_SCHEDULE_LINE_PERCENTAGE TP_SCHEDULE_LINE_PERCENTAGE
, EI.TP_RULE_PERCENTAGE TP_RULE_PERCENTAGE
, EI.CC_MARKUP_BASE_CODE MARKUP_CALC_BASE_CODE
, EI.TP_BASE_AMOUNT TP_BASE_AMOUNT
, EI.DENOM_RAW_COST DENOM_RAW_COST
, EI.DENOM_BURDENED_COST DENOM_BURDENED_COST
, EI.RAW_REVENUE RAW_REVENUE
, SYS.LABOR_NON_LABOR_FLAG LABOR_NON_LABOR_FLAG
, DECODE(FNTRN1.ENABLED_FLAG
, 'Y'
, FNTRN1.FUNCTION_TRANSACTION_CODE
, 'ALL') FN_TRN_CODE_BORR
, DECODE(FNTRN1.ENABLED_FLAG
, 'Y'
, DECODE(FNTRN1.FUNCTION_TRANSACTION_CODE
, 'LAB'
, 1
, 'USG'
, 2
, 'ER'
, 3
, 'SUP'
, 4
, 'MIS'
, 5
, 'INV'
, 6
, 'WIP'
, 7)
, 0 ) FN_TRN_NUM_BORR
, DECODE( FNTRN2.ENABLED_FLAG
, 'Y'
, FNTRN2.FUNCTION_TRANSACTION_CODE
, 'ALL') FN_TRN_CODE_LENT
, DECODE(FNTRN2.ENABLED_FLAG
, 'Y'
, DECODE(FNTRN2.FUNCTION_TRANSACTION_CODE
, 'LAB'
, 1
, 'USG'
, 2
, 'ER'
, 3
, 'SUP'
, 4
, 'MIS'
, 5
, 'INV'
, 6
, 'WIP'
, 7)
, 0 ) FN_TRN_NUM_LENT
, EI.ORG_ID FROM PA_TASKS T
, PA_PROJECTS_ALL P
, PA_EXPENDITURES_ALL EXP
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURE_TYPES ET
, PA_FUNCTION_TRANSACTIONS FNTRN1
, PA_FUNCTION_TRANSACTIONS FNTRN2
, PA_SYSTEM_LINKAGES SYS
, HR_ALL_ORGANIZATION_UNITS_TL EXPORG
, HR_ALL_ORGANIZATION_UNITS_TL PROJORG
, HR_ALL_ORGANIZATION_UNITS_TL TASKORG
, HR_ALL_ORGANIZATION_UNITS_TL PRVORG
, HR_ALL_ORGANIZATION_UNITS_TL RCVORG
, HR_ALL_ORGANIZATION_UNITS_TL NLORG
, HR_ALL_ORGANIZATION_UNITS_TL RCVOU
, FND_LANGUAGES LANG
, PA_EMPLOYEES PER
WHERE EXP.EXPENDITURE_STATUS_CODE = 'APPROVED' AND EXP.EXPENDITURE_ID = EI.EXPENDITURE_ID AND T.TASK_ID = EI.TASK_ID
AND T.PROJECT_ID = P.PROJECT_ID AND EI. CC_BL_DISTRIBUTED_CODE = 'N' AND EI.COST_DISTRIBUTED_FLAG = 'Y' AND EI.SYSTEM_LINKAGE_FUNCTION NOT IN ('BTC')
AND ET.EXPENDITURE_TYPE = EI.EXPENDITURE_TYPE
AND EI.SYSTEM_LINKAGE_FUNCTION = SYS.FUNCTION
AND FNTRN1.FUNCTION_TRANSACTION_CODE = SYS.CC_FUNCTION_TRANSACTION_CODE
AND FNTRN1.FUNCTION_CODE = 'CBR'
AND FNTRN2.FUNCTION_CODE = 'CLN'
AND FNTRN2.FUNCTION_TRANSACTION_CODE = SYS.CC_FUNCTION_TRANSACTION_CODE AND PRVORG.ORGANIZATION_ID = EI.CC_PRVDR_ORGANIZATION_ID AND RCVORG.ORGANIZATION_ID = EI.CC_RECVR_ORGANIZATION_ID AND NLORG.ORGANIZATION_ID(+) = EI.ORGANIZATION_ID AND RCVOU.ORGANIZATION_ID = P.ORG_ID AND EXP.INCURRED_BY_PERSON_ID= PER.PERSON_ID(+) AND DECODE(EI.OVERRIDE_TO_ORGANIZATION_ID
, NULL
, EXP.INCURRED_BY_ORGANIZATION_ID) = EXPORG.ORGANIZATION_ID AND PROJORG.ORGANIZATION_ID = P.CARRYING_OUT_ORGANIZATION_ID AND TASKORG.ORGANIZATION_ID = T.CARRYING_OUT_ORGANIZATION_ID
AND EXPORG.LANGUAGE = LANG.LANGUAGE_CODE
AND PROJORG.LANGUAGE = LANG.LANGUAGE_CODE
AND TASKORG.LANGUAGE = LANG.LANGUAGE_CODE
AND PRVORG.LANGUAGE = LANG.LANGUAGE_CODE
AND RCVORG.LANGUAGE = LANG.LANGUAGE_CODE
AND DECODE(EI.ORGANIZATION_ID
, NULL
, 'A'
, NLORG.LANGUAGE) = DECODE(EI.ORGANIZATION_ID
, NULL
, 'A'
, LANG.LANGUAGE_CODE)
AND RCVOU.LANGUAGE = LANG.LANGUAGE_CODE AND LANG.INSTALLED_FLAG = 'B' AND FNTRN1.ORG_ID = EI.ORG_ID ORDER BY EXPENDITURE_ITEM_ID

Columns