DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_FACTS dependencies on PA_ADW_R_BGT_LINES_V

Line 1907: PA_ADW_R_BGT_LINES_V PBGT,

1903: SUM(PBGT.BGT_QUANTITY) BGT_QUANTITY,
1904: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
1905: PBGT.BGT_UNIT_OF_MEASURE
1906: FROM
1907: PA_ADW_R_BGT_LINES_V PBGT,
1908: PA_ADW_LOWEST_TASKS_V PT
1909: WHERE
1910: PBGT.TASK_ID = PT.TASK_ID
1911: AND PBGT.PROJECT_ID = x_project_id

Line 1958: PA_ADW_R_BGT_LINES_V PBGT,

1954: SUM(PBGT.BGT_QUANTITY) BGT_QUANTITY,
1955: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
1956: PBGT.BGT_UNIT_OF_MEASURE
1957: FROM
1958: PA_ADW_R_BGT_LINES_V PBGT,
1959: PA_ADW_TOP_TASKS_V PT
1960: WHERE
1961: PBGT.TOP_TASK_ID = PT.TOP_TASK_ID
1962: AND PBGT.PROJECT_ID = x_project_id

Line 2007: PA_ADW_R_BGT_LINES_V PBGT,

2003: SUM(PBGT.BGT_QUANTITY) BGT_QUANTITY,
2004: SUM(PBGT.BGT_LABOR_QUANTITY) BGT_LABOR_QUANTITY,
2005: PBGT.BGT_UNIT_OF_MEASURE
2006: FROM
2007: PA_ADW_R_BGT_LINES_V PBGT,
2008: PA_ADW_PROJECTS_V PP
2009: WHERE
2010: PBGT.PROJECT_ID = PP.PROJECT_ID
2011: AND PBGT.PROJECT_ID = x_project_id