VIEW: APPS.ICX_EDM_BUYER_SUP_PROJ_V

Source

View Text - Preformatted

SELECT DISTINCT DIST.PROJECT_ID , PROJ.SEGMENT1 PROJECT_NUMBER , PROJ.NAME PROJECT_NAME , PROJ.DESCRIPTION PROJECT_DESCRIPTION , PROJ.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID , ORG.NAME ORGANIZATION_NAME , NULL , PROJ.PROJECT_TYPE , PROJ.PROJECT_STATUS_CODE PROJECT_STATUS , PS.PROJECT_STATUS_NAME , PROJ.START_DATE PROJECT_START_DATE , PROJ.COMPLETION_DATE PROJECT_END_DATE , NULL , HEAD.AGENT_ID BUYER_ID , PO_INQ_SV.GET_PERSON_NAME(HEAD.AGENT_ID) , HEAD.VENDOR_ID SUPPLIER_ID , SUPP.VENDOR_NAME SUPPLIER_NAME FROM PO_DISTRIBUTIONS DIST , PO_HEADERS HEAD , PA_PROJECTS_ALL PROJ , HR_ORGANIZATION_UNITS ORG , PA_PROJECT_STATUSES PS , PO_VENDORS SUPP WHERE HEAD.PO_HEADER_ID = DIST.PO_HEADER_ID AND SUPP.VENDOR_ID (+) = HEAD.VENDOR_ID AND PROJ.PROJECT_ID = DIST.PROJECT_ID AND PROJ.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID AND PROJ.TEMPLATE_FLAG != 'Y' AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION SELECT DISTINCT DIST.PROJECT_ID , SEIB.PROJECT_NUMBER , SEIB.PROJECT_NAME , SEIB.PROJECT_NAME PROJECT_DESCRIPTION , SEIB.OPERATING_UNIT ORGANIZATION_ID , ORG.NAME ORGANIZATION_NAME , NULL , TO_CHAR(NULL) PROJECT_TYPE , TO_CHAR(NULL) PROJECT_STATUS , TO_CHAR(NULL) PROJECT_STATUS_DSP , TO_DATE(NULL) PROJECT_START_DATE , TO_DATE(NULL) PROJECT_END_DATE , TO_CHAR(NULL) LAST_ACCUMULATED_PERIOD , HEAD.AGENT_ID BUYER_ID , PO_INQ_SV.GET_PERSON_NAME(HEAD.AGENT_ID) , HEAD.VENDOR_ID SUPPLIER_ID , SUPP.VENDOR_NAME SUPPLIER_NAME FROM PO_DISTRIBUTIONS DIST , PO_HEADERS HEAD , PO_VENDORS SUPP , PJM_SEIBAN_NUMBERS SEIB , HR_ORGANIZATION_UNITS ORG WHERE HEAD.PO_HEADER_ID = DIST.PO_HEADER_ID AND SUPP.VENDOR_ID (+) = HEAD.VENDOR_ID AND SEIB.PROJECT_ID = DIST.PROJECT_ID AND ORG.ORGANIZATION_ID(+) = SEIB.OPERATING_UNIT

View Text - HTML Formatted

SELECT DISTINCT DIST.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION PROJECT_DESCRIPTION
, PROJ.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, NULL
, PROJ.PROJECT_TYPE
, PROJ.PROJECT_STATUS_CODE PROJECT_STATUS
, PS.PROJECT_STATUS_NAME
, PROJ.START_DATE PROJECT_START_DATE
, PROJ.COMPLETION_DATE PROJECT_END_DATE
, NULL
, HEAD.AGENT_ID BUYER_ID
, PO_INQ_SV.GET_PERSON_NAME(HEAD.AGENT_ID)
, HEAD.VENDOR_ID SUPPLIER_ID
, SUPP.VENDOR_NAME SUPPLIER_NAME
FROM PO_DISTRIBUTIONS DIST
, PO_HEADERS HEAD
, PA_PROJECTS_ALL PROJ
, HR_ORGANIZATION_UNITS ORG
, PA_PROJECT_STATUSES PS
, PO_VENDORS SUPP
WHERE HEAD.PO_HEADER_ID = DIST.PO_HEADER_ID
AND SUPP.VENDOR_ID (+) = HEAD.VENDOR_ID
AND PROJ.PROJECT_ID = DIST.PROJECT_ID
AND PROJ.CARRYING_OUT_ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND PROJ.TEMPLATE_FLAG != 'Y'
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION SELECT DISTINCT DIST.PROJECT_ID
, SEIB.PROJECT_NUMBER
, SEIB.PROJECT_NAME
, SEIB.PROJECT_NAME PROJECT_DESCRIPTION
, SEIB.OPERATING_UNIT ORGANIZATION_ID
, ORG.NAME ORGANIZATION_NAME
, NULL
, TO_CHAR(NULL) PROJECT_TYPE
, TO_CHAR(NULL) PROJECT_STATUS
, TO_CHAR(NULL) PROJECT_STATUS_DSP
, TO_DATE(NULL) PROJECT_START_DATE
, TO_DATE(NULL) PROJECT_END_DATE
, TO_CHAR(NULL) LAST_ACCUMULATED_PERIOD
, HEAD.AGENT_ID BUYER_ID
, PO_INQ_SV.GET_PERSON_NAME(HEAD.AGENT_ID)
, HEAD.VENDOR_ID SUPPLIER_ID
, SUPP.VENDOR_NAME SUPPLIER_NAME
FROM PO_DISTRIBUTIONS DIST
, PO_HEADERS HEAD
, PO_VENDORS SUPP
, PJM_SEIBAN_NUMBERS SEIB
, HR_ORGANIZATION_UNITS ORG
WHERE HEAD.PO_HEADER_ID = DIST.PO_HEADER_ID
AND SUPP.VENDOR_ID (+) = HEAD.VENDOR_ID
AND SEIB.PROJECT_ID = DIST.PROJECT_ID
AND ORG.ORGANIZATION_ID(+) = SEIB.OPERATING_UNIT