VIEW: APPS.CZ_CONFIG_V

Source

View Text - Preformatted

SELECT CI.CONFIG_HDR_ID, CI.CONFIG_REV_NBR, DD.CONFIG_ITEM_QTY, DD.config_item_id, QM.ITEM_QTY, DD.QUOTED_LIST_PRICE, QH.ORDER_SUBMITTED_DATE, QH.USER_ID_CREATED, QH.QUOTE_REV_NBR, QH.QUOTE_HDR_ID, CI.PS_NODE_ID, QH.ORACLE_PRICING_FLAG, DD.DISC_PERCENTAGE, PN.ITEM_ID FROM CZ_DRILL_DOWN_ITEMS DD, CZ_QUOTE_MAIN_ITEMS QM, CZ_QUOTE_HDRS QH, CZ_CONFIG_ITEMS CI, CZ_PS_NODES PN WHERE QM.QUOTE_HDR_ID = QH.QUOTE_HDR_ID AND QM.QUOTE_REV_NBR = QH.QUOTE_REV_NBR AND DD.QUOTE_HDR_ID = QH.QUOTE_HDR_ID AND DD.QUOTE_REV_NBR = QH.QUOTE_REV_NBR AND QM.ITEM_SEQ_NUMBER = DD.ITEM_SEQ_NUMBER AND DD.CONFIG_HDR_ID = CI.CONFIG_HDR_ID AND DD.CONFIG_REV_NBR = CI.CONFIG_REV_NBR AND DD.CONFIG_ITEM_ID = CI.CONFIG_ITEM_ID AND CI.PS_NODE_ID=PN.PS_NODE_ID 

View Text - HTML Formatted

SELECT CI.CONFIG_HDR_ID
, CI.CONFIG_REV_NBR
, DD.CONFIG_ITEM_QTY
, DD.CONFIG_ITEM_ID
, QM.ITEM_QTY
, DD.QUOTED_LIST_PRICE
, QH.ORDER_SUBMITTED_DATE
, QH.USER_ID_CREATED
, QH.QUOTE_REV_NBR
, QH.QUOTE_HDR_ID
, CI.PS_NODE_ID
, QH.ORACLE_PRICING_FLAG
, DD.DISC_PERCENTAGE
, PN.ITEM_ID
FROM CZ_DRILL_DOWN_ITEMS DD
, CZ_QUOTE_MAIN_ITEMS QM
, CZ_QUOTE_HDRS QH
, CZ_CONFIG_ITEMS CI
, CZ_PS_NODES PN
WHERE QM.QUOTE_HDR_ID = QH.QUOTE_HDR_ID
AND QM.QUOTE_REV_NBR = QH.QUOTE_REV_NBR
AND DD.QUOTE_HDR_ID = QH.QUOTE_HDR_ID
AND DD.QUOTE_REV_NBR = QH.QUOTE_REV_NBR
AND QM.ITEM_SEQ_NUMBER = DD.ITEM_SEQ_NUMBER
AND DD.CONFIG_HDR_ID = CI.CONFIG_HDR_ID
AND DD.CONFIG_REV_NBR = CI.CONFIG_REV_NBR
AND DD.CONFIG_ITEM_ID = CI.CONFIG_ITEM_ID
AND CI.PS_NODE_ID=PN.PS_NODE_ID