APPS.OE_ORDER_PRICE_PVT dependencies on OE_ORDER_PRICE_ATTRIBS

Line 795: from oe_order_price_attribs a

791: pricing_attribute90 , pricing_attribute91 , pricing_attribute92 , pricing_attribute93 ,
792: pricing_attribute94 , pricing_attribute95 , pricing_attribute96 , pricing_attribute97 ,
793: pricing_attribute98 , pricing_attribute99 , pricing_attribute100
794: ,Override_Flag
795: from oe_order_price_attribs a
796: where (a.line_id is null and a.header_id = p_header_id )
797: union all
798: select flex_title, pricing_context, pricing_attribute1,
799: pricing_attribute2 , pricing_attribute3 , pricing_attribute4 , pricing_attribute5 ,

Line 825: from oe_order_price_attribs a

821: pricing_attribute90 , pricing_attribute91 , pricing_attribute92 , pricing_attribute93 ,
822: pricing_attribute94 , pricing_attribute95 , pricing_attribute96 , pricing_attribute97 ,
823: pricing_attribute98 , pricing_attribute99 , pricing_attribute100
824: ,Override_Flag
825: from oe_order_price_attribs a
826: where (p_line_id is not null and a.line_id = p_line_id);
827:
828: --l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
829: px_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

Line 6743: (select 'x' from oe_order_price_attribs oopa

6739: Begin
6740: l_header_id2:=nvl(p_header_id, l_line_tbl(line_tbl_index).header_id);
6741: Select 'x' into l_dummy from dual
6742: Where exists
6743: (select 'x' from oe_order_price_attribs oopa
6744: where nvl(oopa.line_id,l_Line_Tbl(line_Tbl_Index).line_id) = l_Line_Tbl(line_Tbl_Index).line_id
6745: and oopa.header_id = l_header_id2);
6746:
6747:

Line 6896: Select 'X' from oe_order_price_attribs oopa

6892: Begin
6893: l_header_id2:= nvl(p_header_id,l_line_tbl(l_line_tbl.first).header_id);
6894: Select 'x' into l_dummy from dual
6895: where exists(
6896: Select 'X' from oe_order_price_attribs oopa
6897: where oopa.header_id = l_header_id2 and oopa.line_id is null);
6898:
6899: -- AG change --
6900: Append_asked_for(