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 PO_DISTRIBUTIONS_ALL

Line 1644: FROM po_distributions_all d,

1640: l.unit_meas_lookup_code,
1641: oola.shipped_quantity,
1642: uom.unit_of_measure,
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

Line 1666: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;

1662: and TRANSACTION_STATUS_CODE <> 'ERROR'
1663: AND PROCESSING_STATUS_CODE <> 'ERROR')
1664: ORDER BY d.distribution_num; --If multiple Replenishment PO Distributions exist then handle in their order.
1665:
1666: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1667: l_distribution_num po_distributions_all.distribution_num%TYPE;
1668: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1669: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1670: --l_receive_quantity NUMBER;

Line 1667: l_distribution_num po_distributions_all.distribution_num%TYPE;

1663: AND PROCESSING_STATUS_CODE <> 'ERROR')
1664: ORDER BY d.distribution_num; --If multiple Replenishment PO Distributions exist then handle in their order.
1665:
1666: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1667: l_distribution_num po_distributions_all.distribution_num%TYPE;
1668: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1669: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1670: --l_receive_quantity NUMBER;
1671: l_insert_quantity NUMBER;

Line 1668: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;

1664: ORDER BY d.distribution_num; --If multiple Replenishment PO Distributions exist then handle in their order.
1665:
1666: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1667: l_distribution_num po_distributions_all.distribution_num%TYPE;
1668: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1669: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1670: --l_receive_quantity NUMBER;
1671: l_insert_quantity NUMBER;
1672: l_allocated_quantity NUMBER;

Line 1669: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;

1665:
1666: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1667: l_distribution_num po_distributions_all.distribution_num%TYPE;
1668: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1669: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1670: --l_receive_quantity NUMBER;
1671: l_insert_quantity NUMBER;
1672: l_allocated_quantity NUMBER;
1673:

Line 1675: l_prm_uom_quantity_ordered po_distributions_all.quantity_ordered%TYPE;

1671: l_insert_quantity NUMBER;
1672: l_allocated_quantity NUMBER;
1673:
1674: -- Bug#5647346
1675: l_prm_uom_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1676: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1677: l_prm_uom_allocated_quantity NUMBER;
1678: l_prm_uom_receive_quantity NUMBER;
1679: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

Line 1676: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;

1672: l_allocated_quantity NUMBER;
1673:
1674: -- Bug#5647346
1675: l_prm_uom_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1676: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1677: l_prm_uom_allocated_quantity NUMBER;
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;