DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on OE_ORDER_LINES_ALL

Line 521: p_line_rec.orig_sys_shipment_ref(p_index) = 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1')

517: AND org_id = p_line_rec.org_id(p_index)
518: AND (nvl(orig_sys_shipment_ref,fnd_api.g_miss_char)
519: = nvl(p_line_rec.orig_sys_shipment_ref(p_index),fnd_api.g_miss_char)
520: OR -- added to fix bug 5394064
521: p_line_rec.orig_sys_shipment_ref(p_index) = 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1')
522: -- Bug 2764130 : there should be only one row for this doc/line ref
523: -- combination. If there are multiple rows, it will be errored out in
524: -- the duplicate check in procedure Entity.
525: AND rownum = 1;

Line 1703: := 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1';

1699: AND p_line_rec.orig_sys_shipment_ref(p_index) IS NULL
1700: AND nvl(p_line_rec.source_document_id(p_index),0) <> 10
1701: THEN
1702: p_line_rec.orig_sys_shipment_ref(p_index)
1703: := 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1';
1704: END IF;
1705:
1706: IF p_line_rec.ship_from_org_id(p_index) IS NOT NULL THEN
1707: p_line_rec.re_source_flag(p_index) := 'N';

Line 2206: from oe_order_lines_all

2202: -- values then
2203:
2204: select unit_selling_price, payment_term_id
2205: into l_unit_selling_price, l_payment_term_id
2206: from oe_order_lines_all
2207: where line_id = p_line_rec.line_id(p_line_index);
2208:
2209: IF nvl(p_line_rec.customer_item_net_price(p_line_index)
2210: ,l_unit_selling_price)