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 398: FROM jmf_shikyu_replenishments r

394: l_lines_id line_id_tbl := line_id_tbl();
395:
396: CURSOR replenish_so_line_c IS
397: SELECT r.replenishment_so_line_id
398: FROM jmf_shikyu_replenishments r
399: WHERE r.replenishment_so_header_id = p_header_id;
400:
401: BEGIN
402:

Line 442: FROM jmf_shikyu_replenishments r

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

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

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

Line 1647: jmf_shikyu_replenishments jsr,

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