DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_FACTS dependencies on PA_ADW_BGT_LINES_V

Line 2056: PA_ADW_BGT_LINES_V PBGT,

2052: SUM(PBGT.BGT_QUANTITY) BGT_QUANTITY,
2053: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
2054: PBGT.BGT_UNIT_OF_MEASURE
2055: FROM
2056: PA_ADW_BGT_LINES_V PBGT,
2057: PA_ADW_LOWEST_TASKS_V PT
2058: WHERE
2059: PBGT.TASK_ID = PT.TASK_ID
2060: -- Exclude the tasks which are top tasks

Line 2107: PA_ADW_BGT_LINES_V PBGT,

2103: SUM(PBGT.BGT_QUANTITY) BGT_QUANTITY,
2104: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
2105: PBGT.BGT_UNIT_OF_MEASURE
2106: FROM
2107: PA_ADW_BGT_LINES_V PBGT,
2108: PA_ADW_TOP_TASKS_V PT
2109: WHERE
2110: PBGT.TOP_TASK_ID = PT.TOP_TASK_ID
2111: AND PBGT.PROJECT_ID = x_project_id

Line 2156: PA_ADW_BGT_LINES_V PBGT,

2152: SUM(PBGT.BGT_QUANTITY) BGT_QUANTITY,
2153: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
2154: PBGT.BGT_UNIT_OF_MEASURE
2155: FROM
2156: PA_ADW_BGT_LINES_V PBGT,
2157: PA_ADW_PROJECTS_V PP
2158: WHERE
2159: PBGT.PROJECT_ID = PP.PROJECT_ID
2160: AND PBGT.PROJECT_ID = x_project_id