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 ,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

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
, 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