DBA Data[Home] [Help]

APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 1549: , qp_pricing_attributes attr

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

Line 1613: , qp_pricing_attributes attr

1609: FROM qp_npreq_lines_tmp line
1610: ,qp_npreq_ldets_tmp adj_pbh
1611: ,qp_npreq_rltd_lines_tmp ass
1612: ,qp_npreq_ldets_tmp adj
1613: , qp_pricing_attributes attr
1614: -- WHERE p_request_type_code <> 'ONT'
1615: --bug 3085453 handle pricing availability UI
1616: -- they pass reqtype ONT and insert adj into ldets
1617: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG <> QP_PREQ_PUB.G_YES

Line 3331: from qp_pricing_attributes

3327: THEN
3328: BEGIN
3329: select pricing_attribute
3330: into QP_PREQ_PUB.G_pbhvolattr_attribute(l_adj_tbl(d).created_from_list_line_id)
3331: from qp_pricing_attributes
3332: where list_line_id =
3333: l_adj_tbl(d).created_from_list_line_id
3334: and excluder_flag='N'; --3607956
3335: EXCEPTION