POR_REQ_LINES_IN_POOL_SRC_V

Details

• Schema: FUSION

• Object owner: POR

• Object type: VIEW

Columns

Name
REQUISITION_HEADER_ID REQUISITION_NUMBER REQUISITION_LINE_ID LINE_NUMBER QUANTITY NEED_BY_DATE CREATION_DATE MODIFIED_BY_BUYER_FLAG AUCTION_HEADER_ID AUCTION_LINE_NUMBER REQ_BU_ID PROJECT_NUMBER TASK_NUMBER

Query

SQL_Statement

SELECT PRH.REQUISITION_HEADER_ID, PRH.REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, PRL.LINE_NUMBER, PRL.QUANTITY, PRL.NEED_BY_DATE, PRL.CREATION_DATE, PRL.MODIFIED_BY_BUYER_FLAG, PRL.AUCTION_HEADER_ID, PRL.AUCTION_LINE_NUMBER, PRH.REQ_BU_ID, DECODE(TO_CHAR(COUNT(DISTINCT(PRD.PJC_PROJECT_ID))),'1', TO_CHAR(MAX(PAP.SEGMENT1)) ,'0',TO_CHAR(NULL),'MULTIPLE') PROJECT_NUMBER , DECODE(TO_CHAR(COUNT(DISTINCT(PRD.PJC_TASK_ID))), '1', TO_CHAR(MAX(PAT.TASK_NUMBER)),'0',TO_CHAR(NULL),'MULTIPLE') TASK_NUMBER FROM POR_REQUISITION_HEADERS_ALL PRH, POR_REQUISITION_LINES_ALL PRL, POR_REQ_DISTRIBUTIONS_ALL PRD, PJF_PROJECTS_ALL_VL PAP, PJF_TASKS_V PAT, PON_BACKING_REQUISITIONS PBR WHERE PRH.REQUISITION_HEADER_ID=PRL.REQUISITION_HEADER_ID AND PRL.REQUISITION_LINE_ID =PRD.REQUISITION_LINE_ID AND NVL(PRL.CANCEL_FLAG,'N')='N' AND PRD.PJC_PROJECT_ID=PAP.PROJECT_ID(+) AND PRD.PJC_TASK_ID=PAT.TASK_ID(+) and PBR.Requisition_line_id = prl.requisition_line_id GROUP BY PRH.REQUISITION_HEADER_ID, PRH.REQUISITION_NUMBER, PRL.REQUISITION_LINE_ID, PRL.LINE_NUMBER, PRL.QUANTITY, PRL.NEED_BY_DATE, PRL.CREATION_DATE, PRL.MODIFIED_BY_BUYER_FLAG, PRH.REQ_BU_ID, PRL.AUCTION_HEADER_ID, PRL.AUCTION_LINE_NUMBER