APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on OE_ORDER_HEADERS_ALL

Line 256: l_header_id oe_order_headers_all.header_id%TYPE;

252: )
253: IS
254:
255: l_api_name VARCHAR2(50) := 'auto_receive_by_inventory';
256: l_header_id oe_order_headers_all.header_id%TYPE;
257: l_customer_id NUMBER;
258: l_customer_site_id NUMBER;
259:
260:

Line 264: FROM oe_order_headers_all h

260:
261: CURSOR replenish_so_c(customer_id NUMBER, customer_site VARCHAR2)
262: IS
263: SELECT h.header_id
264: FROM oe_order_headers_all h
265: WHERE
266: h.header_id IN (SELECT DISTINCT r.replenishment_so_header_id FROM jmf_shikyu_replenishments r)
267: AND h.org_Id = p_org_id
268: AND h.sold_to_org_id = customer_id

Line 387: l_ship_from_org_id oe_order_headers_all.ship_from_org_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;
391:

Line 388: l_ship_to_org_id oe_order_headers_all.ship_to_org_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;
391:
392: l_primary_uom_code VARCHAR2(30);

Line 389: l_ship_method oe_order_headers_all.shipping_method_code%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;
391:
392: l_primary_uom_code VARCHAR2(30);
393:

Line 510: FROM oe_order_headers_all

506: SELECT
507: shipping_method_code
508: INTO
509: l_ship_method
510: FROM oe_order_headers_all
511: WHERE header_id = p_header_id;
512:
513: END IF;
514:

Line 723: l_ship_from_org_id_h oe_order_headers_all.ship_from_org_id%TYPE;

719: )
720: IS
721: l_api_name VARCHAR2(30) := 'validate_ship_from_to';
722:
723: l_ship_from_org_id_h oe_order_headers_all.ship_from_org_id%TYPE;
724: l_ship_to_org_id_h oe_order_headers_all.ship_to_org_id%TYPE;
725:
726: l_ship_flag NUMBER;
727:

Line 724: l_ship_to_org_id_h oe_order_headers_all.ship_to_org_id%TYPE;

720: IS
721: l_api_name VARCHAR2(30) := 'validate_ship_from_to';
722:
723: l_ship_from_org_id_h oe_order_headers_all.ship_from_org_id%TYPE;
724: l_ship_to_org_id_h oe_order_headers_all.ship_to_org_id%TYPE;
725:
726: l_ship_flag NUMBER;
727:
728: BEGIN

Line 742: FROM oe_order_headers_all h

738: SELECT h.ship_from_org_id
739: , h.ship_to_org_id
740: INTO l_ship_from_org_id_h
741: , l_ship_to_org_id_h
742: FROM oe_order_headers_all h
743: WHERE h.header_id = p_header_id;
744: EXCEPTION
745: WHEN no_data_found THEN
746: JMF_SHIKYU_UTIL.debug_output