DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on OE_ORDER_LINES_ALL

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

491: AND org_id = p_line_rec.org_id(p_index)
492: AND (nvl(orig_sys_shipment_ref,fnd_api.g_miss_char)
493: = nvl(p_line_rec.orig_sys_shipment_ref(p_index),fnd_api.g_miss_char)
494: OR -- added to fix bug 5394064
495: p_line_rec.orig_sys_shipment_ref(p_index) = 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1')
496: -- Bug 2764130 : there should be only one row for this doc/line ref
497: -- combination. If there are multiple rows, it will be errored out in
498: -- the duplicate check in procedure Entity.
499: AND rownum = 1;

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

1671: AND p_line_rec.orig_sys_shipment_ref(p_index) IS NULL
1672: AND nvl(p_line_rec.source_document_id(p_index),0) <> 10
1673: THEN
1674: p_line_rec.orig_sys_shipment_ref(p_index)
1675: := 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1';
1676: END IF;
1677:
1678: IF p_line_rec.ship_from_org_id(p_index) IS NOT NULL THEN
1679: p_line_rec.re_source_flag(p_index) := 'N';

Line 2151: from oe_order_lines_all

2147: -- values then
2148:
2149: select unit_selling_price, payment_term_id
2150: into l_unit_selling_price, l_payment_term_id
2151: from oe_order_lines_all
2152: where line_id = p_line_rec.line_id(p_line_index);
2153:
2154: IF nvl(p_line_rec.customer_item_net_price(p_line_index)
2155: ,l_unit_selling_price)