[Home] [Help]
1623: --Bug:8598002 renamed p_retro_pricing to p_pricing_call_src, to distinguish calls from retro and auto creation
1624: AND DECODE(NVL(p_pricing_call_src,'NULL'), 'RETRO', 'N',
1625: DECODE(NVL(p_allow_price_override_flag,'Y'), 'Y', NVL(ADJD.updated_flag, 'N'), 'N')) = 'N' --to avoid deleting overridden-automatic and manual modifiers in normal mode
1626: --AND ADJD.pricing_phase_id IN (SELECT QPP.pricing_phase_id --this condition has to be checked for pass and fail scenarios, right now it fails for most of the cases
1627: -- FROM qp_event_phases QEP
1628: -- ,qp_pricing_phases QPP
1629: -- WHERE instr(p_pricing_events, QEP.pricing_event_code || ',') > 0
1630: -- AND QPP.pricing_phase_id = QEP.pricing_phase_id
1631: -- AND NVL(QPP.user_freeze_override_flag, QPP.freeze_override_flag)
2133: WHERE LDETS.list_line_id = ADJ.list_line_id
2134: AND ADJ.draft_id = p_draft_id --For now draft_id in this place can never be null, but this condition needs to be changed or removed if null value is allowed in draft_id
2135: AND LDETS.line_index = QPL.line_index
2136: AND ADJ.pricing_phase_id IN (SELECT QEP.pricing_phase_id
2137: FROM qp_event_phases QEP
2138: WHERE instr(p_pricing_events, QEP.pricing_event_code || ',') > 0)
2139: AND LDETS.process_code IN (QP_PREQ_GRP.G_STATUS_UNCHANGED, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_NEW)
2140: AND nvl(ADJ.updated_flag, 'N') = 'N'
2141: AND QPL.line_id = ADJ.po_line_id