673: SELECT
674: PROJECT_ID,
675: SEGMENT1
676: FROM
677: PA_ADW_PROJECTS_V
678: WHERE segment1 BETWEEN NVL(x_project_num_from,segment1)
679: AND NVL(x_project_num_to,segment1);
680:
681: -- define procedure variables
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
2012: AND PBGT.ADW_NOTIFY_FLAG = 'R'
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
2161: AND PBGT.ADW_NOTIFY_FLAG = 'S'
2180: SELECT
2181: PROJECT_ID,
2182: SEGMENT1
2183: FROM
2184: PA_ADW_PROJECTS_V
2185: WHERE segment1 BETWEEN NVL(x_project_num_from,segment1)
2186: AND NVL(x_project_num_to,segment1);
2187:
2188: -- define procedure variables