eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ICX_EDM_CUSTOMER_PROJ_V

Product:	ICX - Oracle iProcurement
Description:	Project Information Summary View by Customer
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CUST.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
, CUST.CUSTOMER_ID
, RACUST.CUSTOMER_NUMBER
, RACUST.CUSTOMER_NAME
, RACUST.PRIMARY_SALESREP_ID
, SLSREP.NAME SALESPERSON
, CUST.CUSTOMER_BILL_SPLIT
FROM PA_PROJECT_CUSTOMERS CUST
, RA_CUSTOMERS RACUST
, PA_PROJECTS_ALL PROJ
, HR_ORGANIZATION_UNITS ORG
, RA_SALESREPS SLSREP
, PA_PROJECT_STATUSES PS
WHERE RACUST.CUSTOMER_ID = CUST.CUSTOMER_ID
AND PROJ.PROJECT_ID = CUST.PROJECT_ID
AND ORG.ORGANIZATION_ID(+) = PROJ.CARRYING_OUT_ORGANIZATION_ID
AND SLSREP.SALESREP_ID(+) = RACUST.PRIMARY_SALESREP_ID
AND PROJ.TEMPLATE_FLAG != 'Y'
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION SELECT DISTINCT PROJ.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
, PS.PROJECT_STATUS_NAME
, PROJ.START_DATE PROJECT_START_DATE
, PROJ.COMPLETION_DATE PROJECT_END_DATE
, RACUST.CUSTOMER_ID
, RACUST.CUSTOMER_NUMBER
, RACUST.CUSTOMER_NAME
, RACUST.PRIMARY_SALESREP_ID
, SLSREP.NAME SALESPERSON
, TO_NUMBER(NULL)
FROM SO_LINES LINE
, SO_HEADERS HEAD
, RA_CUSTOMERS RACUST
, PA_PROJECTS_ALL PROJ
, HR_ORGANIZATION_UNITS ORG
, RA_SALESREPS SLSREP
, PA_PROJECT_STATUSES PS
WHERE RACUST.CUSTOMER_ID = HEAD.CUSTOMER_ID
AND PROJ.PROJECT_ID = LINE.PROJECT_ID
AND LINE.HEADER_ID = HEAD.HEADER_ID
AND ORG.ORGANIZATION_ID(+) = PROJ.CARRYING_OUT_ORGANIZATION_ID
AND SLSREP.SALESREP_ID(+) = RACUST.PRIMARY_SALESREP_ID
AND PROJ.TEMPLATE_FLAG != 'Y'
AND PS.PROJECT_STATUS_CODE = PROJ.PROJECT_STATUS_CODE UNION SELECT DISTINCT LINE.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
, HEAD.CUSTOMER_ID
, RACUST.CUSTOMER_NUMBER
, RACUST.CUSTOMER_NAME
, RACUST.PRIMARY_SALESREP_ID
, SLSREP.NAME SALESPERSON
, TO_NUMBER(NULL) CUSTOMER_BILL_SPLIT
FROM SO_LINES LINE
, SO_HEADERS HEAD
, PJM_SEIBAN_NUMBERS SEIB
, RA_CUSTOMERS RACUST
, RA_SALESREPS SLSREP
, HR_ORGANIZATION_UNITS ORG
WHERE HEAD.HEADER_ID = LINE.HEADER_ID
AND SEIB.PROJECT_ID = LINE.PROJECT_ID
AND ORG.ORGANIZATION_ID(+) = SEIB.OPERATING_UNIT
AND RACUST.CUSTOMER_ID = HEAD.CUSTOMER_ID
AND SLSREP.SALESREP_ID(+) = RACUST.PRIMARY_SALESREP_ID

Columns

Name
PROJECT_ID
PROJECT_NUMBER
PROJECT_NAME
PROJECT_DESCRIPTION
PROJECT_ORGANIZATION_ID
PROJECT_ORGANIZATION
PROJECT_CATEGORY
PROJECT_TYPE
PROJECT_STATUS
STATUS_DSP
PROJECT_START_DATE
PROJECT_END_DATE
CUSTOMER_ID
CUSTOMER_NUMBER
CUSTOMER_NAME
PRIMARY_SALESREP_ID
SALESPERSON
CUSTOMER_BILL_SPLIT