DBA Data[Home] [Help]

APPS.OZF_PRICELIST_PVT dependencies on QP_LIST_LINES

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

Line 1225: FROM qp_list_lines

1221: l_list_header_detail c_list_header_detail%ROWTYPE;
1222:
1223: CURSOR c_list_line_detail (l_list_line_id NUMBER) IS
1224: SELECT *
1225: FROM qp_list_lines
1226: WHERE list_line_id = l_list_line_id;
1227: l_list_line_detail c_list_line_detail%ROWTYPE;
1228:
1229: CURSOR c_pricing_detail (l_list_line_id NUMBER) IS

Line 1237: SELECT qp_list_lines_s.NEXTVAL

1233: l_pricing_detail c_pricing_detail%ROWTYPE;
1234:
1235:
1236: CURSOR c_list_line_id IS
1237: SELECT qp_list_lines_s.NEXTVAL
1238: FROM DUAL;
1239:
1240: CURSOR c_pricing_attr_id IS
1241: SELECT qp_pricing_attributes_s.NEXTVAL

Line 1287: INSERT INTO qp_list_lines(list_line_id

1283: OPEN c_pricing_attr_id;
1284: FETCH c_pricing_attr_id INTO l_pricing_attr_id;
1285: CLOSE c_pricing_attr_id;
1286:
1287: INSERT INTO qp_list_lines(list_line_id
1288: ,accrual_qty
1289: ,accrual_uom_code
1290: ,arithmetic_operator
1291: ,attribute1