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 1664: FROM po_distributions_all d,

1660: l.unit_meas_lookup_code,
1661: oola.shipped_quantity,
1662: uom.unit_of_measure,
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

Line 1686: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;

1682: and TRANSACTION_STATUS_CODE <> 'ERROR'
1683: AND PROCESSING_STATUS_CODE <> 'ERROR')
1684: ORDER BY d.distribution_num; --If multiple Replenishment PO Distributions exist then handle in their order.
1685:
1686: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1687: l_distribution_num po_distributions_all.distribution_num%TYPE;
1688: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1689: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1690: --l_receive_quantity NUMBER;

Line 1687: l_distribution_num po_distributions_all.distribution_num%TYPE;

1683: AND PROCESSING_STATUS_CODE <> 'ERROR')
1684: ORDER BY d.distribution_num; --If multiple Replenishment PO Distributions exist then handle in their order.
1685:
1686: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1687: l_distribution_num po_distributions_all.distribution_num%TYPE;
1688: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1689: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1690: --l_receive_quantity NUMBER;
1691: l_insert_quantity NUMBER;

Line 1688: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;

1684: ORDER BY d.distribution_num; --If multiple Replenishment PO Distributions exist then handle in their order.
1685:
1686: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1687: l_distribution_num po_distributions_all.distribution_num%TYPE;
1688: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1689: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1690: --l_receive_quantity NUMBER;
1691: l_insert_quantity NUMBER;
1692: l_allocated_quantity NUMBER;

Line 1689: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;

1685:
1686: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;
1687: l_distribution_num po_distributions_all.distribution_num%TYPE;
1688: l_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1689: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1690: --l_receive_quantity NUMBER;
1691: l_insert_quantity NUMBER;
1692: l_allocated_quantity NUMBER;
1693:

Line 1695: l_prm_uom_quantity_ordered po_distributions_all.quantity_ordered%TYPE;

1691: l_insert_quantity NUMBER;
1692: l_allocated_quantity NUMBER;
1693:
1694: -- Bug#5647346
1695: l_prm_uom_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1696: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1697: l_prm_uom_allocated_quantity NUMBER;
1698: l_prm_uom_receive_quantity NUMBER;
1699: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;

Line 1696: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;

1692: l_allocated_quantity NUMBER;
1693:
1694: -- Bug#5647346
1695: l_prm_uom_quantity_ordered po_distributions_all.quantity_ordered%TYPE;
1696: l_prm_uom_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
1697: l_prm_uom_allocated_quantity NUMBER;
1698: l_prm_uom_receive_quantity NUMBER;
1699: l_primary_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;
1700: l_po_uom mtl_units_of_measure_tl.unit_of_measure%TYPE;