APPS.OE_PREPAYMENT_PVT dependencies on OE_ORDER_LINES_ALL

Line 39: FROM oe_order_lines_all ool

35: *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
36: INTO
37: l_tax_total
38: , l_order_total
39: FROM oe_order_lines_all ool
40: WHERE ool.header_id = p_header_id
41: AND ool.open_flag = 'N'
42: AND ool.cancelled_flag = 'N'
43: AND ool.line_category_code <> 'RETURN'

Line 61: FROM mtl_system_items mti, oe_order_lines_all ool

57: FROM oe_payments op
58: WHERE op.header_id = p_header_id
59: AND NOT EXISTS
60: (SELECT 'Non Invoiceable Item Line'
61: FROM mtl_system_items mti, oe_order_lines_all ool
62: WHERE ool.line_id = op.line_id
63: AND mti.inventory_item_id = ool.inventory_item_id
64: AND mti.organization_id = nvl(ool.ship_from_org_id,
65: oe_sys_parameters.value('MASTER_ORGANIZATION_ID'))

Line 72: FROM oe_order_lines_all ool

68: ELSE
69: -- Select the Outbound Extended Price for lines that have committment
70: SELECT SUM(ROUND(nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price), OE_ORDER_UTIL.G_Precision))
71: INTO l_commitment_total
72: FROM oe_order_lines_all ool
73: WHERE ool.header_id = p_header_id
74: AND ool.commitment_id is not null
75: AND ool.open_flag = 'N'
76: AND ool.cancelled_flag = 'N'

Line 117: OE_ORDER_LINES_ALL L

113: )
114: )
115: INTO l_chgs_w_line_id
116: FROM OE_PRICE_ADJUSTMENTS P,
117: OE_ORDER_LINES_ALL L
118: WHERE P.HEADER_ID = p_header_id
119: AND P.LINE_ID = L.LINE_ID
120: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
121: AND P.APPLIED_FLAG = 'Y'

Line 2716: FROM oe_order_lines_all

2712: -- create a new trxn_extension_id for the child line from the parent line
2713: BEGIN
2714: SELECT org_id, invoice_to_org_id
2715: INTO l_org_id, l_site_use_id
2716: FROM oe_order_lines_all
2717: WHERE line_id = p_line_id;
2718: EXCEPTION WHEN NO_DATA_FOUND THEN
2719: null;
2720: END;

Line 2932: FROM oe_order_lines_all

2928:
2929: BEGIN
2930: SELECT header_id
2931: INTO l_header_id
2932: FROM oe_order_lines_all
2933: WHERE line_id = p_line_id;
2934: EXCEPTION
2935: WHEN OTHERS THEN
2936: IF l_debug_level > 0 THEN

Line 3141: ,oe_order_lines_all ool

3137: BEGIN
3138: SELECT payment_set_id
3139: INTO l_payment_set_id
3140: FROM oe_payments op
3141: ,oe_order_lines_all ool
3142: WHERE op.header_id = ool.header_id
3143: AND ool.line_id = p_line_id
3144: AND op.payment_collection_event = 'PREPAY'
3145: AND rownum = 1;

Line 3708: from oe_order_lines_all

3704: Savepoint update_line;
3705:
3706: select line_id, payment_type_code, commitment_id
3707: into l_lock_line_id, line_payment_type, line_commitment_id
3708: from oe_order_lines_all
3709: where line_id = p_line_id
3710: for update nowait;
3711:
3712: if l_lock_line_id is null then

Line 3744: update oe_order_lines_all

3740: end loop;
3741:
3742: if l_pmt_changed = 'Y' then
3743: Begin
3744: update oe_order_lines_all
3745: set payment_type_code = line_payment_type,
3746: commitment_id = line_commitment_id
3747: where line_id = l_lock_line_id;
3748:

Line 5050: FROM oe_order_lines_all

5046:
5047: CURSOR lines_cur(p_header_id IN NUMBER) IS
5048: SELECT line_id
5049: ,payment_term_id
5050: FROM oe_order_lines_all
5051: WHERE header_id = p_header_id;
5052:
5053: CURSOR exc_inv_lines_cur(p_header_id IN NUMBER) IS
5054: SELECT line_id

Line 5056: FROM oe_order_lines_all

5052:
5053: CURSOR exc_inv_lines_cur(p_header_id IN NUMBER) IS
5054: SELECT line_id
5055: ,payment_term_id
5056: FROM oe_order_lines_all
5057: WHERE header_id = p_header_id
5058: AND nvl(invoice_interface_status_code,'NO') <> 'YES';
5059:
5060: l_pay_now_total_detail_tbl AR_VIEW_TERM_GRP.amounts_table;

Line 5097: FROM oe_order_lines_all

5093: ,payment_term_id
5094: INTO l_line_tbl(1).line_id
5095: ,l_line_tbl(1).header_id
5096: ,l_line_tbl(1).payment_term_id
5097: FROM oe_order_lines_all
5098: WHERE line_id=p_line_id;
5099: ELSE
5100: -- this is for header payment
5101: i := 1;