VIEW: APPS.PSA_CST_XLA_UPG_V

Source

View Text - Preformatted

SELECT rcv.transaction_id, CASE WHEN (rcv.source_document_Code='PO' ) THEN ( SELECT PSA_BC_XLA_PUB.GET_SLA_NOTUPGRADED_FLAG(201,DECODE(rcv.po_release_id, NULL, 'PURCHASE_ORDER', 'RELEASE'), NVL (rcv.po_release_id, rcv.po_header_id),'PO_DISTRIBUTIONS_ALL',rcv.po_distribution_id) FROM po_headers_all poh, FINANCIALS_SYSTEM_PARAMS_ALL FSP WHERE POH.ORG_ID = FSP.ORG_ID AND POH.PO_HEADER_ID = RCV.PO_HEADER_ID AND (fsp.req_encumbrance_flag ='Y' OR fsp.PURCH_ENCUMBRANCE_FLAG = 'Y')) WHEN (rcv.source_document_Code='REQ' ) THEN (SELECT PSA_BC_XLA_PUB.GET_SLA_NOTUPGRADED_FLAG(201,'PURCHASE_ORDER', REQLINE.REQUISITION_HEADER_ID,'PO_REQ_DISTRIBUTIONS_ALL',RCV.REQ_DISTRIBUTION_ID) FROM po_req_distributions_all REQDIST ,PO_REQUISITION_LINES_ALL REQLINE, FINANCIALS_SYSTEM_PARAMS_ALL FSP WHERE REQDIST.ORG_ID = FSP.ORG_ID AND REQDIST.DISTRIBUTION_ID = RCV.REQ_DISTRIBUTION_ID AND REQDIST.REQUISITION_LINE_ID = REQLINE.REQUISITION_LINE_ID AND RCV.REQUISITION_LINE_ID = REQLINE.REQUISITION_LINE_ID AND (fsp.req_encumbrance_flag ='Y' OR fsp.PURCH_ENCUMBRANCE_FLAG = 'Y')) ELSE 'N' END "CST_ENCUM_UPG_OPTION" FROM RCV_TRANSACTIONS RCV

View Text - HTML Formatted

SELECT RCV.TRANSACTION_ID
, CASE WHEN (RCV.SOURCE_DOCUMENT_CODE='PO' ) THEN ( SELECT PSA_BC_XLA_PUB.GET_SLA_NOTUPGRADED_FLAG(201
, DECODE(RCV.PO_RELEASE_ID
, NULL
, 'PURCHASE_ORDER'
, 'RELEASE')
, NVL (RCV.PO_RELEASE_ID
, RCV.PO_HEADER_ID)
, 'PO_DISTRIBUTIONS_ALL'
, RCV.PO_DISTRIBUTION_ID)
FROM PO_HEADERS_ALL POH
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE POH.ORG_ID = FSP.ORG_ID
AND POH.PO_HEADER_ID = RCV.PO_HEADER_ID
AND (FSP.REQ_ENCUMBRANCE_FLAG ='Y' OR FSP.PURCH_ENCUMBRANCE_FLAG = 'Y')) WHEN (RCV.SOURCE_DOCUMENT_CODE='REQ' ) THEN (SELECT PSA_BC_XLA_PUB.GET_SLA_NOTUPGRADED_FLAG(201
, 'PURCHASE_ORDER'
, REQLINE.REQUISITION_HEADER_ID
, 'PO_REQ_DISTRIBUTIONS_ALL'
, RCV.REQ_DISTRIBUTION_ID)
FROM PO_REQ_DISTRIBUTIONS_ALL REQDIST
, PO_REQUISITION_LINES_ALL REQLINE
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE REQDIST.ORG_ID = FSP.ORG_ID
AND REQDIST.DISTRIBUTION_ID = RCV.REQ_DISTRIBUTION_ID
AND REQDIST.REQUISITION_LINE_ID = REQLINE.REQUISITION_LINE_ID
AND RCV.REQUISITION_LINE_ID = REQLINE.REQUISITION_LINE_ID
AND (FSP.REQ_ENCUMBRANCE_FLAG ='Y' OR FSP.PURCH_ENCUMBRANCE_FLAG = 'Y')) ELSE 'N' END "CST_ENCUM_UPG_OPTION"
FROM RCV_TRANSACTIONS RCV