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 507: FROM oe_order_headers_all

503: SELECT
504: shipping_method_code
505: INTO
506: l_ship_method
507: FROM oe_order_headers_all
508: WHERE header_id = p_header_id;
509:
510: END IF;
511:

Line 717: l_ship_from_org_id_h oe_order_headers_all.ship_from_org_id%TYPE;

713: )
714: IS
715: l_api_name VARCHAR2(30) := 'validate_ship_from_to';
716:
717: l_ship_from_org_id_h oe_order_headers_all.ship_from_org_id%TYPE;
718: l_ship_to_org_id_h oe_order_headers_all.ship_to_org_id%TYPE;
719:
720: l_ship_flag NUMBER;
721:

Line 718: l_ship_to_org_id_h oe_order_headers_all.ship_to_org_id%TYPE;

714: IS
715: l_api_name VARCHAR2(30) := 'validate_ship_from_to';
716:
717: l_ship_from_org_id_h oe_order_headers_all.ship_from_org_id%TYPE;
718: l_ship_to_org_id_h oe_order_headers_all.ship_to_org_id%TYPE;
719:
720: l_ship_flag NUMBER;
721:
722: BEGIN

Line 736: FROM oe_order_headers_all h

732: SELECT h.ship_from_org_id
733: , h.ship_to_org_id
734: INTO l_ship_from_org_id_h
735: , l_ship_to_org_id_h
736: FROM oe_order_headers_all h
737: WHERE h.header_id = p_header_id;
738: EXCEPTION
739: WHEN no_data_found THEN
740: JMF_SHIKYU_UTIL.debug_output