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.JMF_SHIKYU_AUTO_RCV_PROC dependencies on OE_ORDER_LINES_ALL

Line 375: l_line_id oe_order_lines_all.line_id%TYPE;

371: )
372: IS
373:
374: l_api_name VARCHAR2(20):= 'auto_receive';
375: l_line_id oe_order_lines_all.line_id%TYPE;
376:
377: l_auto_receive_quantity oe_order_lines_all.shipped_quantity%TYPE;
378:
379: l_date_flag NUMBER;

Line 377: l_auto_receive_quantity oe_order_lines_all.shipped_quantity%TYPE;

373:
374: l_api_name VARCHAR2(20):= 'auto_receive';
375: l_line_id oe_order_lines_all.line_id%TYPE;
376:
377: l_auto_receive_quantity oe_order_lines_all.shipped_quantity%TYPE;
378:
379: l_date_flag NUMBER;
380: l_ship_flag NUMBER;
381:

Line 390: l_sold_to_org_id oe_order_lines_all.sold_to_org_id%TYPE;

386: l_ship_date oe_order_lines.ACTUAL_SHIPMENT_DATE%TYPE;
387: l_ship_from_org_id oe_order_headers_all.ship_from_org_id%TYPE;
388: l_ship_to_org_id oe_order_headers_all.ship_to_org_id%TYPE;
389: l_ship_method oe_order_headers_all.shipping_method_code%TYPE;
390: l_sold_to_org_id oe_order_lines_all.sold_to_org_id%TYPE;
391:
392: l_primary_uom_code VARCHAR2(30);
393:
394: l_lines_id line_id_tbl := line_id_tbl();

Line 490: FROM oe_order_lines_all l

486: , l_ship_from_org_id
487: , l_ship_to_org_id
488: , l_sold_to_org_id
489: , l_ship_method
490: FROM oe_order_lines_all l
491: WHERE l.line_id = l_line_id;
492:
493: EXCEPTION
494: WHEN no_data_found THEN

Line 499: ,p_message => 'no data find when select ship org id or other info by line_id in oe_order_lines_all'

495: JMF_SHIKYU_UTIL.debug_output
496: (
497: p_output_to => 'FND_LOG.STRING'
498: ,p_api_name => l_api_name
499: ,p_message => 'no data find when select ship org id or other info by line_id in oe_order_lines_all'
500: );
501: END;
502:
503: --get ship method from SO header

Line 1003: l_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE;

999: )
1000: IS
1001:
1002: l_api_name VARCHAR2(40) := 'compare_lines_quantity';
1003: l_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE;
1004: l_line_quantity oe_order_lines_all.shipped_quantity%TYPE;
1005: l_returned_quantity NUMBER;
1006: l_received_quantity NUMBER;
1007:

Line 1004: l_line_quantity oe_order_lines_all.shipped_quantity%TYPE;

1000: IS
1001:
1002: l_api_name VARCHAR2(40) := 'compare_lines_quantity';
1003: l_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE;
1004: l_line_quantity oe_order_lines_all.shipped_quantity%TYPE;
1005: l_returned_quantity NUMBER;
1006: l_received_quantity NUMBER;
1007:
1008: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE;

Line 1016: l_item_id oe_order_lines_all.inventory_item_id%TYPE;

1012:
1013: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1014: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
1015:
1016: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1017: l_uom_code oe_order_lines_all.shipping_quantity_uom%TYPE;
1018:
1019: l_backorder_shipped_quantity NUMBER;
1020:

Line 1017: l_uom_code oe_order_lines_all.shipping_quantity_uom%TYPE;

1013: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1014: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
1015:
1016: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1017: l_uom_code oe_order_lines_all.shipping_quantity_uom%TYPE;
1018:
1019: l_backorder_shipped_quantity NUMBER;
1020:
1021: l_index NUMBER;

Line 1055: FROM oe_order_lines_all l

1051: , l.order_quantity_uom -- Bug#5647346: changed to order_quantity_uom from shipping_quantity_uom since the shipped_quantity is order_quantity_uom
1052: INTO l_line_quantity
1053: , l_item_id
1054: , l_uom_code
1055: FROM oe_order_lines_all l
1056: WHERE l.line_id = p_lines_id(l_index);
1057:
1058: EXCEPTION
1059: WHEN no_data_found THEN

Line 1239: FROM oe_order_lines_all l

1235: , l.inventory_item_id
1236: --, l.shipping_quantity_uom
1237: , l.order_quantity_uom -- Bug#5647346: changed to order_quantity_uom from shipping_quantity_uom since the shipped_quantity is order_quantity_uom
1238:
1239: FROM oe_order_lines_all l
1240: WHERE l.split_from_line_id = p_line_id
1241: AND l.header_id = p_so_header_id;
1242: BEGIN
1243:

Line 1261: oe_order_lines_all

1257: COUNT(*)
1258: INTO
1259: l_line_count
1260: FROM
1261: oe_order_lines_all
1262: WHERE header_id = p_so_header_id;
1263:
1264: IF l_line_count < 2
1265: THEN

Line 1639: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;

1635: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1636: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1637: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1638: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1639: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1640: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1641:
1642: l_group_id rcv_headers_interface.group_id%TYPE;
1643: l_return_number NUMBER;

Line 1640: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;

1636: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1637: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1638: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1639: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1640: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1641:
1642: l_group_id rcv_headers_interface.group_id%TYPE;
1643: l_return_number NUMBER;
1644: --l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;

Line 1668: oe_order_lines_all oola

1664: FROM po_distributions_all d,
1665: po_line_locations_all l,
1666: MTL_UNITS_OF_MEASURE uom,
1667: jmf_shikyu_replenishments jsr,
1668: oe_order_lines_all oola
1669: WHERE d.line_location_id = p_location_id
1670: AND d.LINE_LOCATION_ID = jsr.replenishment_PO_shipment_ID
1671: and oola.line_id = jsr.replenishment_so_line_id
1672: and nvl(oola.shipped_quantity, 0) > 0

Line 1702: l_item_id oe_order_lines_all.inventory_item_id%TYPE;

1698: l_prm_uom_receive_quantity NUMBER;
1699: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1700: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1701: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1702: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1703:
1704: BEGIN
1705: JMF_SHIKYU_UTIL.debug_output
1706: (

Line 2086: FROM OE_ORDER_LINES_ALL oola

2082: --get the project id and task id
2083: BEGIN
2084: SELECT oola.project_id, oola.task_id
2085: INTO l_project_id, l_task_id
2086: FROM OE_ORDER_LINES_ALL oola
2087: WHERE oola.line_id = p_lines_id(l_index);
2088: EXCEPTION
2089: WHEN no_data_found THEN
2090: JMF_SHIKYU_UTIL.debug_output