DBA Data[Home] [Help]

APPS.OZF_PRICELIST_PVT dependencies on QP_LIST_HEADERS_B

Line 1209: FROM qp_pricing_attributes qpa, qp_list_lines qll, qp_list_headers_b qlh

1205: v_pricing_attr_val_tbl QP_PRICE_LIST_PUB.Pricing_Attr_Val_Tbl_Type;
1206:
1207: CURSOR c_list_header_line_id (l_source_system_code VARCHAR2) IS
1208: SELECT DISTINCT qpa.list_header_id, qpa.list_line_id
1209: FROM qp_pricing_attributes qpa, qp_list_lines qll, qp_list_headers_b qlh
1210: WHERE qll.list_line_id = qpa.list_line_id
1211: AND qpa.product_attribute = 'PRICING_ATTRIBUTE1'
1212: AND qpa.product_attr_value = TO_CHAR(p_org_inv_item_id)
1213: AND qlh.list_header_id = qpa.list_header_id