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 JMF_SHIKYU_REPLENISHMENTS

Line 266: h.header_id IN (SELECT DISTINCT r.replenishment_so_header_id FROM jmf_shikyu_replenishments r)

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
269: -- AND h.header_id = r.replenishment_so_header_id
270: -- AND h.sold_to_site_use_id = customer_site

Line 382: l_po_header_id jmf_shikyu_replenishments.replenishment_po_header_id%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;

Line 383: l_po_line_id jmf_shikyu_replenishments.replenishment_po_line_id%TYPE;

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;

Line 384: l_po_shipment_id jmf_shikyu_replenishments.replenishment_po_shipment_id%TYPE;

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;

Line 401: FROM jmf_shikyu_replenishments r

397: l_inventory_org_id NUMBER := p_inventory_org_id;
398:
399: CURSOR replenish_so_line_c IS
400: SELECT r.replenishment_so_line_id
401: FROM jmf_shikyu_replenishments r
402: WHERE r.replenishment_so_header_id = p_header_id;
403:
404: BEGIN
405:

Line 445: FROM jmf_shikyu_replenishments r

441: INTO
442: l_po_header_id
443: , l_po_line_id
444: , l_po_shipment_id
445: FROM jmf_shikyu_replenishments r
446: WHERE r.replenishment_so_line_id = l_line_id;
447: EXCEPTION
448: WHEN no_data_found THEN
449: JMF_SHIKYU_UTIL.debug_output

Line 453: ,p_message => 'no data find when select PO info by so_line_id in jmf_shikyu_replenishments'

449: JMF_SHIKYU_UTIL.debug_output
450: (
451: p_output_to => 'FND_LOG.STRING'
452: ,p_api_name => l_api_name
453: ,p_message => 'no data find when select PO info by so_line_id in jmf_shikyu_replenishments'
454: );
455: END;
456:
457: -- begin debug log

Line 1667: jmf_shikyu_replenishments jsr,

1663: oola.inventory_item_id
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