DBA Data[Home] [Help]

APPS.MSC_X_VMI_POREQ dependencies on OE_ORDER_LINES_ALL

Line 1305: from oe_order_lines_all

1301: /* only for New Sales orders and not for Cons. Adv sales orders */
1302: begin
1303: select SCHEDULE_ARRIVAL_DATE, SCHEDULE_SHIP_DATE,ship_from_org_id
1304: into lv_schedule_arrival_date,lv_schedule_ship_date,lv_shipping_org
1305: from oe_order_lines_all
1306: where line_id = l_line_tbl(1).line_id;
1307: exception
1308: when others then
1309: log_message('Error in getting Scheduled Arrival Date');