DBA Data[Home] [Help]

VIEW: APPS.QP_PRICE_REQ_SOURCES_V

Source

View Text - Preformatted

SELECT qp_pte_rt.REQUEST_TYPE_CODE, qp_pte_ss.APPLICATION_SHORT_NAME SOURCE_SYSTEM_CODE FROM QP_PTE_REQUEST_TYPES_B qp_pte_rt, QP_PTE_SOURCE_SYSTEMS qp_pte_ss WHERE qp_pte_rt.PTE_CODE = qp_pte_SS.PTE_CODE AND qp_pte_ss.ENABLED_FLAG='Y'
View Text - HTML Formatted

SELECT QP_PTE_RT.REQUEST_TYPE_CODE
, QP_PTE_SS.APPLICATION_SHORT_NAME SOURCE_SYSTEM_CODE
FROM QP_PTE_REQUEST_TYPES_B QP_PTE_RT
, QP_PTE_SOURCE_SYSTEMS QP_PTE_SS
WHERE QP_PTE_RT.PTE_CODE = QP_PTE_SS.PTE_CODE
AND QP_PTE_SS.ENABLED_FLAG='Y'