VIEW: APPS.PA_ADW_LOWTSK_BGT_LINES_V

Source

View Text - Preformatted

SELECT FACT.PROJECT_ID, FACT.TOP_TASK_ID, FACT.TASK_ID, FACT.PA_PERIOD_KEY, FACT.BUDGET_TYPE_CODE, FACT.RESOURCE_LIST_MEMBER_ID, FACT.SERVICE_TYPE_CODE, FACT.OWNER_ORGANIZATION_ID, FACT.EXPENDITURE_TYPE, FACT.USER_COL1, FACT.USER_COL2, FACT.USER_COL3, FACT.USER_COL4, FACT.USER_COL5, FACT.USER_COL6, FACT.USER_COL7, FACT.USER_COL8, FACT.USER_COL9, FACT.USER_COL10, FACT.BGT_RAW_COST, FACT.BGT_BURDENED_COST, FACT.BGT_REVENUE, FACT.BGT_QUANTITY, FACT.BGT_LABOR_QUANTITY, FACT.BGT_UNIT_OF_MEASURE, FACT.ADW_NOTIFY_FLAG FROM PA_ADW_BGT_LINES_B_V FACT, PA_ADW_LOWEST_TASKS_V TASK WHERE FACT.TASK_ID = TASK.TASK_ID

View Text - HTML Formatted

SELECT FACT.PROJECT_ID
, FACT.TOP_TASK_ID
, FACT.TASK_ID
, FACT.PA_PERIOD_KEY
, FACT.BUDGET_TYPE_CODE
, FACT.RESOURCE_LIST_MEMBER_ID
, FACT.SERVICE_TYPE_CODE
, FACT.OWNER_ORGANIZATION_ID
, FACT.EXPENDITURE_TYPE
, FACT.USER_COL1
, FACT.USER_COL2
, FACT.USER_COL3
, FACT.USER_COL4
, FACT.USER_COL5
, FACT.USER_COL6
, FACT.USER_COL7
, FACT.USER_COL8
, FACT.USER_COL9
, FACT.USER_COL10
, FACT.BGT_RAW_COST
, FACT.BGT_BURDENED_COST
, FACT.BGT_REVENUE
, FACT.BGT_QUANTITY
, FACT.BGT_LABOR_QUANTITY
, FACT.BGT_UNIT_OF_MEASURE
, FACT.ADW_NOTIFY_FLAG
FROM PA_ADW_BGT_LINES_B_V FACT
, PA_ADW_LOWEST_TASKS_V TASK
WHERE FACT.TASK_ID = TASK.TASK_ID