[Home] [Help]
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;
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:
382: l_po_header_id jmf_shikyu_replenishments.replenishment_po_header_id%TYPE;
383: l_po_line_id jmf_shikyu_replenishments.replenishment_po_line_id%TYPE;
384: l_po_shipment_id jmf_shikyu_replenishments.replenishment_po_shipment_id%TYPE;
385:
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;
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();
483: , l_ship_from_org_id
484: , l_ship_to_org_id
485: , l_sold_to_org_id
486: , l_ship_method
487: FROM oe_order_lines_all l
488: WHERE l.line_id = l_line_id;
489:
490: EXCEPTION
491: WHEN no_data_found THEN
492: JMF_SHIKYU_UTIL.debug_output
493: (
494: p_output_to => 'FND_LOG.STRING'
495: ,p_api_name => l_api_name
496: ,p_message => 'no data find when select ship org id or other info by line_id in oe_order_lines_all'
497: );
498: END;
499:
500: --get ship method from SO header
979: )
980: IS
981:
982: l_api_name VARCHAR2(40) := 'compare_lines_quantity';
983: l_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE;
984: l_line_quantity oe_order_lines_all.shipped_quantity%TYPE;
985: l_returned_quantity NUMBER;
986: l_received_quantity NUMBER;
987:
980: IS
981:
982: l_api_name VARCHAR2(40) := 'compare_lines_quantity';
983: l_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE;
984: l_line_quantity oe_order_lines_all.shipped_quantity%TYPE;
985: l_returned_quantity NUMBER;
986: l_received_quantity NUMBER;
987:
988: l_primary_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
992:
993: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
994: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
995:
996: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
997: l_uom_code oe_order_lines_all.shipping_quantity_uom%TYPE;
998:
999: l_backorder_shipped_quantity NUMBER;
1000:
993: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
994: l_po_uom_code mtl_units_of_measure_tl.uom_code%TYPE;
995:
996: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
997: l_uom_code oe_order_lines_all.shipping_quantity_uom%TYPE;
998:
999: l_backorder_shipped_quantity NUMBER;
1000:
1001: l_index NUMBER;
1031: , l.order_quantity_uom -- Bug#5647346: changed to order_quantity_uom from shipping_quantity_uom since the shipped_quantity is order_quantity_uom
1032: INTO l_line_quantity
1033: , l_item_id
1034: , l_uom_code
1035: FROM oe_order_lines_all l
1036: WHERE l.line_id = p_lines_id(l_index);
1037:
1038: EXCEPTION
1039: WHEN no_data_found THEN
1215: , l.inventory_item_id
1216: --, l.shipping_quantity_uom
1217: , l.order_quantity_uom -- Bug#5647346: changed to order_quantity_uom from shipping_quantity_uom since the shipped_quantity is order_quantity_uom
1218:
1219: FROM oe_order_lines_all l
1220: WHERE l.split_from_line_id = p_line_id
1221: AND l.header_id = p_so_header_id;
1222: BEGIN
1223:
1237: COUNT(*)
1238: INTO
1239: l_line_count
1240: FROM
1241: oe_order_lines_all
1242: WHERE header_id = p_so_header_id;
1243:
1244: IF l_line_count < 2
1245: THEN
1615: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1616: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1617: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1618: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1619: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1620: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1621:
1622: l_group_id rcv_headers_interface.group_id%TYPE;
1623: l_return_number NUMBER;
1616: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1617: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1618: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1619: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;
1620: l_task_id OE_ORDER_LINES_ALL.task_id%TYPE;
1621:
1622: l_group_id rcv_headers_interface.group_id%TYPE;
1623: l_return_number NUMBER;
1624: --l_unit_of_measure mtl_units_of_measure_tl.unit_of_measure%TYPE;
1644: FROM po_distributions_all d,
1645: po_line_locations_all l,
1646: MTL_UNITS_OF_MEASURE uom,
1647: jmf_shikyu_replenishments jsr,
1648: oe_order_lines_all oola
1649: WHERE d.line_location_id = p_location_id
1650: AND d.LINE_LOCATION_ID = jsr.replenishment_PO_shipment_ID
1651: and oola.line_id = jsr.replenishment_so_line_id
1652: and nvl(oola.shipped_quantity, 0) > 0
1678: l_prm_uom_receive_quantity NUMBER;
1679: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1680: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1681: l_so_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1682: l_item_id oe_order_lines_all.inventory_item_id%TYPE;
1683:
1684: BEGIN
1685: JMF_SHIKYU_UTIL.debug_output
1686: (
2062: --get the project id and task id
2063: BEGIN
2064: SELECT oola.project_id, oola.task_id
2065: INTO l_project_id, l_task_id
2066: FROM OE_ORDER_LINES_ALL oola
2067: WHERE oola.line_id = p_lines_id(l_index);
2068: EXCEPTION
2069: WHEN no_data_found THEN
2070: JMF_SHIKYU_UTIL.debug_output