DBA Data[Home] [Help]

VIEW: APPS.PA_CI_SUPPLIER_DETAILS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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