DBA Data[Home] [Help]

APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 1545: , qp_pricing_attributes attr

1541: FROM qp_npreq_lines_tmp line
1542: ,oe_price_adjustments adj_pbh
1543: ,oe_price_adj_assocs ass
1544: ,oe_price_adjustments adj
1545: , qp_pricing_attributes attr
1546: -- WHERE p_request_type_code = 'ONT'
1547: --bug 3085453 handle pricing availability UI
1548: -- they pass reqtype ONT and insert adj into ldets
1549: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 1607: , qp_pricing_attributes attr

1603: FROM qp_npreq_lines_tmp line
1604: ,qp_npreq_ldets_tmp adj_pbh
1605: ,qp_npreq_rltd_lines_tmp ass
1606: ,qp_npreq_ldets_tmp adj
1607: , qp_pricing_attributes attr
1608: -- WHERE p_request_type_code <> 'ONT'
1609: --bug 3085453 handle pricing availability UI
1610: -- they pass reqtype ONT and insert adj into ldets
1611: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG <> QP_PREQ_PUB.G_YES

Line 3277: from qp_pricing_attributes

3273: THEN
3274: BEGIN
3275: select pricing_attribute
3276: into QP_PREQ_PUB.G_pbhvolattr_attribute(l_adj_tbl(d).created_from_list_line_id)
3277: from qp_pricing_attributes
3278: where list_line_id =
3279: l_adj_tbl(d).created_from_list_line_id
3280: and excluder_flag='N'; --3607956
3281: EXCEPTION