DBA Data[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on QP_LIST_HEADERS_B

Line 741: qp_list_headers_b where list_header_id=p_list_header_id;

737: Return g_rounding_factor_rec.rounding_factor;
738: Else
739: g_rounding_factor_rec.list_header_id := p_list_header_id;
740: select rounding_factor into g_rounding_factor_rec.rounding_factor from
741: qp_list_headers_b where list_header_id=p_list_header_id;
742:
743: If g_rounding_factor_rec.rounding_factor = fnd_api.g_miss_num then
744: g_rounding_factor_rec.rounding_factor:= Null;
745: End If;

Line 4467: , QP_LIST_HEADERS_B QH

4463: , 1
4464: FROM
4465: QP_LDETS_v ldets
4466: , QP_PREQ_LINES_TMP lines
4467: , QP_LIST_HEADERS_B QH
4468: WHERE
4469: ldets.list_header_id=qh.list_header_id
4470: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
4471: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)