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 |
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
, SI.ORIGINAL_SUPP_TRANS_ID ORIGINAL_SUPP_TRANS_ID
, PCVL.CI_TYPE_CLASS_CODE CI_TYPE_CLASS_CODE
, SI.TASK_ID TASK_ID
, SI.RESOURCE_LIST_MEMBER_ID
, SI.EXPENDITURE_TYPE_ID
, SI.ESTIMATED_COST
, SI.QUOTED_COST
, SI.NEGOTIATED_COST
, SI.MARKUP_COST
, SI.FINAL_COST
, SI.STATUS
, SI.FROM_CHANGE_DATE
, SI.TO_CHANGE_DATE
, SI.RAW_COST
, SI.BURDENED_COST
, SI.REVENUE_RATE
, SI.REVENUE_OVERRIDE_RATE
, SI.REVENUE
, SI.TOTAL_REVENUE
, NULL TASK_NAME
, NULL RESOURCE_NAME
, SI.SUP_QUOTE_REF_NO
, SI.EXPENDITURE_ORG_ID
, SI.CHANGE_REASON_CODE
, SI.QUOTE_NEGOTIATION_REFERENCE
, SI.NEED_BY_DATE
, SI.EXPENDITURE_TYPE
, SI.RESOURCE_ASSIGNMENT_ID
FROM PA_CI_SUPPLIER_DETAILS SI
, PA_CONTROL_ITEMS CI
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_VENDORS POV
, PA_CI_TYPES_VL PCVL
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
AND PCVL.CI_TYPE_ID = CI.CI_TYPE_ID
AND SI.TASK_ID IS NULL
AND SI.RESOURCE_LIST_MEMBER_ID IS NULL 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
, POH.SEGMENT1 PO_NUMBER
, 0 PO_LINE_NUM
, POV.VENDOR_NAME
, CI.STATUS_CODE CI_STATUS
, 0 PO_ORG_ID
, CI.PROJECT_ID PROJECT_ID
, SI.ORIGINAL_SUPP_TRANS_ID ORIGINAL_SUPP_TRANS_ID
, PCVL.CI_TYPE_CLASS_CODE CI_TYPE_CLASS_CODE
, SI.TASK_ID TASK_ID
, SI.RESOURCE_LIST_MEMBER_ID
, SI.EXPENDITURE_TYPE_ID
, SI.ESTIMATED_COST
, SI.QUOTED_COST
, SI.NEGOTIATED_COST
, SI.MARKUP_COST
, SI.FINAL_COST
, SI.STATUS
, SI.FROM_CHANGE_DATE
, SI.TO_CHANGE_DATE
, SI.RAW_COST
, SI.BURDENED_COST
, SI.REVENUE_RATE
, SI.REVENUE_OVERRIDE_RATE
, SI.REVENUE
, SI.TOTAL_REVENUE
, PTA.TASK_NAME
, PRLM.ALIAS
, SI.SUP_QUOTE_REF_NO
, SI.EXPENDITURE_ORG_ID
, SI.CHANGE_REASON_CODE
, SI.QUOTE_NEGOTIATION_REFERENCE
, SI.NEED_BY_DATE
, SI.EXPENDITURE_TYPE
, SI.RESOURCE_ASSIGNMENT_ID
FROM PA_CI_SUPPLIER_DETAILS SI
, PA_CONTROL_ITEMS CI
, PO_VENDORS POV
, PO_HEADERS_ALL POH
, PA_CI_TYPES_VL PCVL
, PA_TASKS PTA
, PA_RESOURCE_LIST_MEMBERS PRLM
WHERE SI.CI_ID = CI.CI_ID
AND SI.VENDOR_ID = POV.VENDOR_ID
AND SI.PO_HEADER_ID = POH.PO_HEADER_ID
AND PCVL.CI_TYPE_ID = CI.CI_TYPE_ID
AND SI.TASK_ID = PTA.TASK_ID
AND SI.RESOURCE_LIST_MEMBER_ID = PRLM.RESOURCE_LIST_MEMBER_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
, SI.ORIGINAL_SUPP_TRANS_ID ORIGINAL_SUPP_TRANS_ID
, PCVL.CI_TYPE_CLASS_CODE CI_TYPE_CLASS_CODE
, SI.TASK_ID TASK_ID
, SI.RESOURCE_LIST_MEMBER_ID
, SI.EXPENDITURE_TYPE_ID
, SI.ESTIMATED_COST
, SI.QUOTED_COST
, SI.NEGOTIATED_COST
, SI.MARKUP_COST
, SI.FINAL_COST
, SI.STATUS
, SI.FROM_CHANGE_DATE
, SI.TO_CHANGE_DATE
, SI.RAW_COST
, SI.BURDENED_COST
, SI.REVENUE_RATE
, SI.REVENUE_OVERRIDE_RATE
, SI.REVENUE
, SI.TOTAL_REVENUE
, PTA.TASK_NAME
, PRLM.ALIAS
, SI.SUP_QUOTE_REF_NO
, SI.EXPENDITURE_ORG_ID
, SI.CHANGE_REASON_CODE
, SI.QUOTE_NEGOTIATION_REFERENCE
, SI.NEED_BY_DATE
, SI.EXPENDITURE_TYPE
, SI.RESOURCE_ASSIGNMENT_ID
FROM PA_CI_SUPPLIER_DETAILS SI
, PA_CONTROL_ITEMS CI
, PO_VENDORS POV
, PA_CI_TYPES_VL PCVL
, PA_TASKS PTA
, PA_RESOURCE_LIST_MEMBERS PRLM
WHERE SI.CI_ID = CI.CI_ID
AND SI.VENDOR_ID = POV.VENDOR_ID
AND PCVL.CI_TYPE_ID = CI.CI_TYPE_ID
AND SI.TASK_ID = PTA.TASK_ID
AND SI.RESOURCE_LIST_MEMBER_ID = PRLM.RESOURCE_LIST_MEMBER_ID
AND SI.PO_HEADER_ID IS NULL