VIEW: APPS.QPR_INT_DEAL_V

Source

View Text - Preformatted

SELECT resh.response_header_id, reql.pn_line_id, resh.response_status, reqh.source_id, reqh.source_ref_hdr_id, reql.source_ref_line_id, reql.uom_code, reql.currency_code, reql.revised_oq, reqp.unit_price, reql.payment_term_id, decode(reql.ship_method_code, '-777', null, reql.ship_method_code), (case when (nvl(reql.revised_oq,0) = nvl(reql.ordered_qty,0) and nvl(reqp.unit_price,0) = nvl(reql.proposed_price,0) and nvl(reql.payment_term_id,0) = nvl(reql.orig_payment_term_id, 0) and nvl(reql.ship_method_code, '-777') = nvl(reql.orig_ship_method_code,'-777')) then 'N' else 'Y' end ) changed from qpr_pn_request_hdrs_b reqh, qpr_pn_response_hdrs resh, qpr_pn_lines reql, qpr_pn_prices reqp, qpr_pn_pr_types pnt WHERE reqh.request_header_id = resh.request_header_id and resh.response_header_id = reql.response_header_id and reql.item_type_code <> 'DUMMY_PARENT' and reql.pn_line_id = reqp.pn_line_id and reqp.pn_pr_type_id = pnt.pn_pr_type_id and pnt.price_type_name='INVPRICE' and reqh.simulation_flag = 'N' and reqh.request_status = 'CLOSED' and resh.response_status = 'ACCEPT'

View Text - HTML Formatted

SELECT RESH.RESPONSE_HEADER_ID
, REQL.PN_LINE_ID
, RESH.RESPONSE_STATUS
, REQH.SOURCE_ID
, REQH.SOURCE_REF_HDR_ID
, REQL.SOURCE_REF_LINE_ID
, REQL.UOM_CODE
, REQL.CURRENCY_CODE
, REQL.REVISED_OQ
, REQP.UNIT_PRICE
, REQL.PAYMENT_TERM_ID
, DECODE(REQL.SHIP_METHOD_CODE
, '-777'
, NULL
, REQL.SHIP_METHOD_CODE)
, (CASE WHEN (NVL(REQL.REVISED_OQ
, 0) = NVL(REQL.ORDERED_QTY
, 0)
AND NVL(REQP.UNIT_PRICE
, 0) = NVL(REQL.PROPOSED_PRICE
, 0)
AND NVL(REQL.PAYMENT_TERM_ID
, 0) = NVL(REQL.ORIG_PAYMENT_TERM_ID
, 0)
AND NVL(REQL.SHIP_METHOD_CODE
, '-777') = NVL(REQL.ORIG_SHIP_METHOD_CODE
, '-777')) THEN 'N' ELSE 'Y' END ) CHANGED
FROM QPR_PN_REQUEST_HDRS_B REQH
, QPR_PN_RESPONSE_HDRS RESH
, QPR_PN_LINES REQL
, QPR_PN_PRICES REQP
, QPR_PN_PR_TYPES PNT
WHERE REQH.REQUEST_HEADER_ID = RESH.REQUEST_HEADER_ID
AND RESH.RESPONSE_HEADER_ID = REQL.RESPONSE_HEADER_ID
AND REQL.ITEM_TYPE_CODE <> 'DUMMY_PARENT'
AND REQL.PN_LINE_ID = REQP.PN_LINE_ID
AND REQP.PN_PR_TYPE_ID = PNT.PN_PR_TYPE_ID
AND PNT.PRICE_TYPE_NAME='INVPRICE'
AND REQH.SIMULATION_FLAG = 'N'
AND REQH.REQUEST_STATUS = 'CLOSED'
AND RESH.RESPONSE_STATUS = 'ACCEPT'