View: PA_CI_SUPPLIER_DETAILS_V

Product:	PA - Projects
Description:	Pa_ci_supplier_details_v is view used to desgin UI screen
Implementation/DBA Data:	APPS.PA_CI_SUPPLIER_DETAILS_V

View Text

SELECT SI.ROWID
, SI.CI_TRANSACTION_ID
, CI.CI_TYPE_ID
, CI.CI_ID
, SI.VENDOR_ID
, SI.PO_HEADER_ID
, SI.PO_LINE_ID
, SI.ADJUSTED_CI_TRANSACTION_ID
, SI.CHANGE_TYPE
, SI.CHANGE_DESCRIPTION
, SI.CREATED_BY
, SI.CURRENCY_CODE
, SI.CHANGE_AMOUNT
, SI.CREATION_DATE
, SI.LAST_UPDATED_BY
, SI.LAST_UPDATE_DATE
, SI.LAST_UPDATE_LOGIN
, POH.SEGMENT1 PO_NUMBER
, POL.LINE_NUM PO_LINE_NUM
, POV.VENDOR_NAME
, CI.STATUS_CODE CI_STATUS
, POH.ORG_ID PO_ORG_ID
, CI.PROJECT_ID PROJECT_ID
FROM PA_CI_SUPPLIER_DETAILS SI
, PA_CONTROL_ITEMS CI
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_VENDORS POV
WHERE SI.CI_ID = CI.CI_ID
AND SI.VENDOR_ID = POV.VENDOR_ID
AND SI.PO_HEADER_ID = POH.PO_HEADER_ID
AND SI.PO_LINE_ID = POL.PO_LINE_ID
AND SI.PO_HEADER_ID= POL.PO_HEADER_ID UNION SELECT SI.ROWID
, SI.CI_TRANSACTION_ID
, CI.CI_TYPE_ID
, CI.CI_ID
, SI.VENDOR_ID
, SI.PO_HEADER_ID
, SI.PO_LINE_ID
, SI.ADJUSTED_CI_TRANSACTION_ID
, SI.CHANGE_TYPE
, SI.CHANGE_DESCRIPTION
, SI.CREATED_BY
, SI.CURRENCY_CODE
, SI.CHANGE_AMOUNT
, SI.CREATION_DATE
, SI.LAST_UPDATED_BY
, SI.LAST_UPDATE_DATE
, SI.LAST_UPDATE_LOGIN
, NULL PO_NUMBER
, 0 PO_LINE_NUM
, POV.VENDOR_NAME
, CI.STATUS_CODE CI_STATUS
, 0 PO_ORG_ID
, CI.PROJECT_ID PROJECT_ID
FROM PA_CI_SUPPLIER_DETAILS SI
, PA_CONTROL_ITEMS CI
, PO_VENDORS POV
WHERE SI.CI_ID = CI.CI_ID
AND SI.VENDOR_ID = POV.VENDOR_ID
AND SI.PO_HEADER_ID IS NULL

Columns