APPS.OE_ORDER_PRICE_PVT dependencies on OE_ORDER_PRICE_ATTRIBS

Line 794: from oe_order_price_attribs a

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

Line 824: from oe_order_price_attribs a

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

Line 6459: oe_order_price_attribs oopa

6455: l_header_id2:=nvl(p_header_id, l_line_tbl(line_tbl_index).header_id);
6456: Select 'x' into l_dummy from dual
6457: Where exists
6458: (select 'x' from
6459: oe_order_price_attribs oopa
6460: where
6461: nvl(oopa.line_id,l_Line_Tbl(line_Tbl_Index).line_id)
6462: = l_Line_Tbl(line_Tbl_Index).line_id
6463: and oopa.header_id = l_header_id2);

Line 6619: Select 'X' from oe_order_price_attribs oopa

6615: l_header_id2:= nvl(p_header_id,l_line_tbl(l_line_tbl.first).header_id);
6616:
6617: Select 'x' into l_dummy from dual
6618: where exists(
6619: Select 'X' from oe_order_price_attribs oopa
6620: where oopa.header_id = l_header_id2 and oopa.line_id is null);
6621:
6622: -- AG change --
6623: Append_asked_for(