DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on QP_EVENT_PHASES

Line 323: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases

319: ,adj.modifier_level_code --Bug 13573144
320: FROM OE_PRICE_ADJUSTMENTS adj
321: WHERE HEADER_ID = oe_order_cache.g_header_rec.header_id
322: AND list_line_Type_code = 'IUE'
323: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
324: where instr(p_pricing_events||',', pricing_event_code||',') >0)
325: AND LINE_ID IN (select line_id
326: from qp_preq_lines_tmp where
327: line_type_code='LINE'

Line 688: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases

684: adj.header_id
685: FROM OE_PRICE_ADJUSTMENTS adj
686: WHERE adj.HEADER_ID = oe_order_cache.g_header_rec.header_id
687: AND adj.list_line_Type_code = 'TSN'
688: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
689: where instr(p_pricing_events||',', pricing_event_code||',')>0)
690: AND adj.LINE_ID IN (select line_id
691: from qp_preq_lines_tmp where
692: line_type_code='LINE'

Line 709: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases

705: adj.header_id
706: FROM OE_PRICE_ADJUSTMENTS adj
707: WHERE adj.HEADER_ID = oe_order_cache.g_header_rec.header_id
708: AND adj.list_line_Type_code = 'TSN'
709: AND adj.PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
710: where instr(p_pricing_events||',', pricing_event_code||',')>0)
711: AND adj.line_id IS NULL
712: AND adj.header_id IN (select line_id
713: from qp_preq_lines_tmp where