APPS.OKS_EXTWARPRGM_PVT dependencies on OE_ORDER_LINES_ALL

Line 69: FROM oe_order_lines_all

65: CURSOR source_line_attrbs_csr
66: IS
67: SELECT invoicing_rule_id, accounting_rule_id, price_list_id,
68: commitment_id, invoice_to_org_id, ship_to_org_id
69: FROM oe_order_lines_all
70: WHERE line_id = p_source_line_id;
71:
72: /*Added for ER 16036980*/
73: CURSOR get_billing_dtls(p_order_line_id NUMBER ) IS

Line 75: FROM oe_order_lines_all

71:
72: /*Added for ER 16036980*/
73: CURSOR get_billing_dtls(p_order_line_id NUMBER ) IS
74: SELECT Nvl(SERVICE_BILL_OPTION_CODE,1),Nvl(SERVICE_BILL_PROFILE_ID,1)
75: FROM oe_order_lines_all
76: WHERE line_id=p_order_line_id;
77:
78: CURSOR get_order_details(p_contract_line_id NUMBER)
79: IS

Line 306: oe_order_lines_all ordline

302: IS
303: SELECT ordline.invoice_to_org_id
304: ,pmt.trxn_extension_id
305: FROM
306: oe_order_lines_all ordline
307: ,oe_payments pmt
308: WHERE ordline.line_id = c_order_line_id
309: AND ordline.header_id = pmt.header_id
310: AND ordline.line_id = pmt.line_id

Line 3918: FROM oe_order_lines_all

3914: /*Added for ER 16036980*/
3915: CURSOR l_pricing_qty(p_order_line_id NUMBER )
3916: IS
3917: SELECT pricing_quantity,pricing_quantity_uom
3918: FROM oe_order_lines_all
3919: WHERE line_id = p_order_line_id;
3920:
3921: CURSOR get_subs_dtls(p_order_line_id NUMBER)
3922: IS

Line 3924: FROM oe_order_lines_all

3920:
3921: CURSOR get_subs_dtls(p_order_line_id NUMBER)
3922: IS
3923: SELECT Nvl(SERVICE_SUBS_TEMPLATE_ID,1)
3924: FROM oe_order_lines_all
3925: WHERE line_id = p_order_line_id;
3926:
3927: l_prc_qty NUMBER;
3928: l_prc_uom VARCHAR2(100);