eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FLM_KANBAN_TRANSFER dependencies on OE_ORDER_LINES_ALL

Line 161: * p_header_id IN This Parameter passes the header id from OE_ORDER_LINES_ALL

157: * p_inter_order_id IN This parameter passes the Internal Sales Order Id
158: * p_inter_line_id IN This Parameter passes the Internal Order Line ID.
159: * p_transfer_qty IN This Parameter passes the Transfer Quantity.
160: * p_kanban_size IN This Parameter passes the Kanban Size.
161: * p_header_id IN This Parameter passes the header id from OE_ORDER_LINES_ALL
162: * p_line_id IN This Parameters passes the line id from OE_ORDER_LINES_ALL
163: * x_errmsg OUT Returns the error message if any.
164: * x_retcode OUT Returns the error code.
165: * Values are: 0 - Normal Completion

Line 162: * p_line_id IN This Parameters passes the line id from OE_ORDER_LINES_ALL

158: * p_inter_line_id IN This Parameter passes the Internal Order Line ID.
159: * p_transfer_qty IN This Parameter passes the Transfer Quantity.
160: * p_kanban_size IN This Parameter passes the Kanban Size.
161: * p_header_id IN This Parameter passes the header id from OE_ORDER_LINES_ALL
162: * p_line_id IN This Parameters passes the line id from OE_ORDER_LINES_ALL
163: * x_errmsg OUT Returns the error message if any.
164: * x_retcode OUT Returns the error code.
165: * Values are: 0 - Normal Completion
166: * 1 - Warning

Line 282: -- Calculating the ln_ship_tolerance_above value to be updated in OE_ORDER_LINES_ALL and WSH_DELIVERY_DETAILS Table

278:
279: IF l_tolerance_param = 1 AND p_transfer_qty > p_kanban_size THEN
280:
281: -- ********************************************************************************************************************
282: -- Calculating the ln_ship_tolerance_above value to be updated in OE_ORDER_LINES_ALL and WSH_DELIVERY_DETAILS Table
283: -- ********************************************************************************************************************
284:
285: l_ship_tolerance_above := (((p_transfer_qty - p_kanban_size) * 100) / p_kanban_size) + 1;
286:

Line 291: UPDATE oe_order_lines_all

287: -- ******************************************************************
288: -- Populating the Order Line information in Line Table Record Type
289: -- ******************************************************************
290:
291: UPDATE oe_order_lines_all
292: SET ship_tolerance_above = ROUND(l_ship_tolerance_above)
293: WHERE header_id = p_header_id
294: AND line_id=p_line_id;
295:

Line 301: oe_order_lines_all oel

297: SET wdd1.ship_tolerance_above = ROUND(l_ship_tolerance_above)
298: WHERE wdd1.delivery_detail_id IN
299: (SELECT delivery_detail_id
300: FROM wsh_delivery_details wdd2,
301: oe_order_lines_all oel
302: WHERE wdd2.source_header_id = oel.header_id
303: AND wdd2.source_line_id = oel.line_id
304: AND oel.source_document_id = p_inter_order_id
305: AND oel.source_document_line_id = p_inter_line_id

Line 1062: * x_header_id OUT Returns the header_id from OE_ORDER_LINES_ALL

1058: * x_inter_line_id OUT Returns the Kanban Internal Sales Order Line Id
1059: * x_intra_order_num OUT Returns the Kanban move order number
1060: * x_intra_order_id OUT Returns the kanban mover order id
1061: * x_intra_line_id OUT Returns the Kanban Move order line id
1062: * x_header_id OUT Returns the header_id from OE_ORDER_LINES_ALL
1063: * x_line_id OUT Returns the line_id from OE_ORDER_LINES_ALL
1064: * x_kanban_size OUT Returns the kanban size
1065: * x_retcode OUT Returns the error code.
1066: * Values are: S - Normal Completion

Line 1063: * x_line_id OUT Returns the line_id from OE_ORDER_LINES_ALL

1059: * x_intra_order_num OUT Returns the Kanban move order number
1060: * x_intra_order_id OUT Returns the kanban mover order id
1061: * x_intra_line_id OUT Returns the Kanban Move order line id
1062: * x_header_id OUT Returns the header_id from OE_ORDER_LINES_ALL
1063: * x_line_id OUT Returns the line_id from OE_ORDER_LINES_ALL
1064: * x_kanban_size OUT Returns the kanban size
1065: * x_retcode OUT Returns the error code.
1066: * Values are: S - Normal Completion
1067: * W - Warning

Line 1127: oe_order_lines_all oel ,

1123: oel.flow_status_code flow_status_code,
1124: oel.line_id line_id,
1125: oel.header_id header_id
1126: FROM oe_order_headers_all oeh,
1127: oe_order_lines_all oel ,
1128: wsh_delivery_details wdd,
1129: mtl_kanban_cards mkc,
1130: mtl_kanban_card_activity mkca
1131: WHERE oeh.source_document_id = mkca.document_header_id

Line 1496: l_inter_line_id oe_order_lines_all.source_document_line_id%TYPE;

1492: l_log_module CONSTANT VARCHAR2(80) := G_LOG_MODULE || l_api_name;
1493:
1494: l_inter_order_num oe_order_headers_all.order_number%TYPE;
1495: l_inter_order_id oe_order_headers_all.source_document_id%TYPE;
1496: l_inter_line_id oe_order_lines_all.source_document_line_id%TYPE;
1497: l_header_id oe_order_headers_all.header_id%TYPE;
1498: l_line_id oe_order_lines_all.line_id%TYPE;
1499: l_intra_order_num mtl_txn_request_headers.request_number%TYPE;
1500: l_intra_order_id mtl_txn_request_headers.header_id%TYPE;

Line 1498: l_line_id oe_order_lines_all.line_id%TYPE;

1494: l_inter_order_num oe_order_headers_all.order_number%TYPE;
1495: l_inter_order_id oe_order_headers_all.source_document_id%TYPE;
1496: l_inter_line_id oe_order_lines_all.source_document_line_id%TYPE;
1497: l_header_id oe_order_headers_all.header_id%TYPE;
1498: l_line_id oe_order_lines_all.line_id%TYPE;
1499: l_intra_order_num mtl_txn_request_headers.request_number%TYPE;
1500: l_intra_order_id mtl_txn_request_headers.header_id%TYPE;
1501: l_intra_line_id mtl_txn_request_lines.line_id%TYPE;
1502: l_organization_id mtl_kanban_cards.organization_id%TYPE;