VIEW: APPS.ICX_EDM_BUYER_SUP_TASK_V

Source

View Text - Preformatted

SELECT DISTINCT DIST.TASK_ID , TASK.TASK_NUMBER , TASK.TASK_NAME , TASK.DESCRIPTION , PEOP.FULL_NAME TASK_MANAGER , TASK.START_DATE , TASK.COMPLETION_DATE , ORG.NAME TASK_ORGANIZATION , TASK.CARRYING_OUT_ORGANIZATION_ID TASK_ORGANIZATION_ID , LOC.LOCATION_CODE TASK_LOCATION , LOC.DESCRIPTION TASK_LOCATION_DESCRIPTION , DIST.PROJECT_ID , PROJ.SEGMENT1 PROJECT_NUMBER , PROJ.NAME PROJECT_NAME , PROJ.DESCRIPTION , POHEAD.AGENT_ID BUYER_ID , PO_INQ_SV.GET_PERSON_NAME(POHEAD.AGENT_ID) , POHEAD.VENDOR_ID SUPPLIER_ID , SUPP.VENDOR_NAME SUPPLIER_NAME FROM PA_PROJECTS_ALL PROJ , PA_TASKS TASK , PER_PEOPLE_F PEOP , HR_ORGANIZATION_UNITS ORG , HR_LOCATIONS LOC , PO_DISTRIBUTIONS_ALL DIST , PO_HEADERS_ALL POHEAD , PO_VENDORS SUPP WHERE POHEAD.PO_HEADER_ID = DIST.PO_HEADER_ID AND SUPP.VENDOR_ID (+) = POHEAD.VENDOR_ID AND TASK.PROJECT_ID = DIST.PROJECT_ID AND TASK.TASK_ID = DIST.TASK_ID AND PROJ.PROJECT_ID = DIST.PROJECT_ID AND PEOP.PERSON_ID(+) = TASK.TASK_MANAGER_PERSON_ID AND ORG.ORGANIZATION_ID = TASK.CARRYING_OUT_ORGANIZATION_ID AND LOC.LOCATION_ID(+) = ORG.LOCATION_ID AND NVL( PROJ.ORG_ID, NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTR( USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99)) = NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTR(USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99) AND NVL( DIST.ORG_ID, NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTR( USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99)) = NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTR(USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99) AND NVL( POHEAD.ORG_ID, NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTR( USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99)) = NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' ), 1, 1), ' ', NULL, SUBSTR(USERENV( 'CLIENT_INFO' ), 1, 10 ))), -99)

View Text - HTML Formatted

SELECT DISTINCT DIST.TASK_ID
, TASK.TASK_NUMBER
, TASK.TASK_NAME
, TASK.DESCRIPTION
, PEOP.FULL_NAME TASK_MANAGER
, TASK.START_DATE
, TASK.COMPLETION_DATE
, ORG.NAME TASK_ORGANIZATION
, TASK.CARRYING_OUT_ORGANIZATION_ID TASK_ORGANIZATION_ID
, LOC.LOCATION_CODE TASK_LOCATION
, LOC.DESCRIPTION TASK_LOCATION_DESCRIPTION
, DIST.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION
, POHEAD.AGENT_ID BUYER_ID
, PO_INQ_SV.GET_PERSON_NAME(POHEAD.AGENT_ID)
, POHEAD.VENDOR_ID SUPPLIER_ID
, SUPP.VENDOR_NAME SUPPLIER_NAME
FROM PA_PROJECTS_ALL PROJ
, PA_TASKS TASK
, PER_PEOPLE_F PEOP
, HR_ORGANIZATION_UNITS ORG
, HR_LOCATIONS LOC
, PO_DISTRIBUTIONS_ALL DIST
, PO_HEADERS_ALL POHEAD
, PO_VENDORS SUPP
WHERE POHEAD.PO_HEADER_ID = DIST.PO_HEADER_ID
AND SUPP.VENDOR_ID (+) = POHEAD.VENDOR_ID
AND TASK.PROJECT_ID = DIST.PROJECT_ID
AND TASK.TASK_ID = DIST.TASK_ID
AND PROJ.PROJECT_ID = DIST.PROJECT_ID
AND PEOP.PERSON_ID(+) = TASK.TASK_MANAGER_PERSON_ID
AND ORG.ORGANIZATION_ID = TASK.CARRYING_OUT_ORGANIZATION_ID
AND LOC.LOCATION_ID(+) = ORG.LOCATION_ID
AND NVL( PROJ.ORG_ID
, NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTR( USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)) = NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)
AND NVL( DIST.ORG_ID
, NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTR( USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)) = NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)
AND NVL( POHEAD.ORG_ID
, NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTR( USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)) = NVL( TO_NUMBER( DECODE( SUBSTR( USERENV( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV( 'CLIENT_INFO' )
, 1
, 10 )))
, -99)