DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_MAIN_PVT dependencies on OE_LINES_IFACE_ALL

Line 39: tabname => 'OE_LINES_IFACE_ALL');

35:
36: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
37: tabname => 'OE_HEADERS_IFACE_ALL');
38: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
39: tabname => 'OE_LINES_IFACE_ALL');
40: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
41: tabname => 'OE_ACTIONS_IFACE_ALL');
42: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
43: tabname => 'OE_PRICE_ADJS_IFACE_ALL');

Line 621: UPDATE oe_lines_iface_all

617:
618:
619: -- start of customer inclusive request_id updates
620:
621: UPDATE oe_lines_iface_all
622: SET request_id = l_request_id
623: WHERE (order_source_id, orig_sys_document_ref, nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
624: ( SELECT order_source_id, orig_sys_document_ref,
625: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR), nvl(org_id,FND_API.G_MISS_NUM)

Line 826: UPDATE oe_lines_iface_all

822:
823: if (l_customer_key_profile <> 'Y') then
824:
825:
826: UPDATE oe_lines_iface_all
827: SET request_id = l_request_id,
828: sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
829: sold_to_org = nvl(sold_to_org, l_sold_to_org),
830: org_id = l_org_id