APPS.CST_PL_IMPORT dependencies on QP_LIST_HEADERS_VL

Line 97: from qp_list_headers_vl qph ,

93: Cursor GET_PL_ITEMS(l_lst_hdr_id number,
94: l_org_id number)
95: IS
96: select distinct msi.inventory_item_id , msi.primary_uom_code
97: from qp_list_headers_vl qph ,
98: qp_list_lines qpl ,
99: qp_pricing_attributes qpa,
100: mtl_system_items_b msi
101: where qph.list_header_id = l_lst_hdr_id

Line 171: from qp_list_headers_vl

167:
168: l_stmt_num := 10 ;
169: Select name
170: into l_price_list_name
171: from qp_list_headers_vl
172: where list_header_id = p_pl_hdr_id ;
173:
174: /* set the values of QP install and Multi Currency Install */
175:

Line 274: from qp_list_headers_vl qph

270: p_control_rec.use_multi_currency := 'Y';
271: else
272:
273: Select qph.currency_code into l_list_currency_code
274: from qp_list_headers_vl qph
275: where qph.list_header_id = p_pl_hdr_id
276: and qph.list_type_code = 'PRL';
277:
278: End If;

Line 330: /* MOAC changes - Send the org_id for the pricing list from qp_list_headers_vl

326: p_control_rec.rounding_flag := 'N'; -- rounding not needed
327:
328:
329: l_stmt_num := 35 ;
330: /* MOAC changes - Send the org_id for the pricing list from qp_list_headers_vl
331: If Security is OFF, the orig_org_id will be null, pricing engine will ignore the OU checks. OK.
332: If security is ON and orig_org_id is not null, it is valid for the OU passed.
333: If the PL is global, orig_org_id will be null, it should still be OK. */
334:

Line 337: from qp_list_headers_vl

333: If the PL is global, orig_org_id will be null, it should still be OK. */
334:
335: Select orig_org_id
336: into p_control_rec.org_id
337: from qp_list_headers_vl
338: where list_header_id = p_pl_hdr_id ;
339:
340: l_stmt_num := 40 ;
341: Open GET_PL_ITEMS( p_pl_hdr_id , p_organization_id );