DBA Data[Home] [Help]

APPS.FLM_SEQ_READER_WRITER dependencies on OE_ORDER_LINES_ALL

Line 591: for sales order: get oe_order_lines_all.demand_class_code

587: l_header NUMBER;
588: BEGIN
589: /*
590: for planned order: can pass null for class code
591: for sales order: get oe_order_lines_all.demand_class_code
592: for existing:
593: */
594: if(i_demand_type = g_demand_type_SO) then
595: SELECT demand_class_code,header_id

Line 597: FROM OE_ORDER_LINES_ALL

593: */
594: if(i_demand_type = g_demand_type_SO) then
595: SELECT demand_class_code,header_id
596: INTO l_demand_class, l_demand_header
597: FROM OE_ORDER_LINES_ALL
598: WHERE line_id = i_demand_id;
599:
600: if(l_demand_header IS NOT NULL) then
601: l_header := inv_salesorder.get_salesorder_for_oeheader(l_demand_header);

Line 624: FROM OE_ORDER_LINES_ALL

620:
621: if(i_demand_type = g_demand_type_SO) then
622: SELECT project_id,task_id
623: INTO l_project_id, l_task_id
624: FROM OE_ORDER_LINES_ALL
625: WHERE line_id = i_demand_id;
626:
627: o_project_id := l_project_id;
628: o_task_id := l_task_id;