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.RCV_AVAILABILITY dependencies on PO_DISTRIBUTIONS_ALL

Line 161: p_project_id IN po_distributions_all.project_id%type,

157: * We need to get the quantity from po_distributions
158: * since we need to match project and task ids.
159: */
160: CURSOR get_po_order(
161: p_project_id IN po_distributions_all.project_id%type,
162: p_task_id IN po_distributions_all.task_id%type) IS
163: SELECT sum(pod.quantity_ordered) quantity,
164: pol.item_id,
165: pol.unit_meas_lookup_code unit_of_measure,

Line 162: p_task_id IN po_distributions_all.task_id%type) IS

158: * since we need to match project and task ids.
159: */
160: CURSOR get_po_order(
161: p_project_id IN po_distributions_all.project_id%type,
162: p_task_id IN po_distributions_all.task_id%type) IS
163: SELECT sum(pod.quantity_ordered) quantity,
164: pol.item_id,
165: pol.unit_meas_lookup_code unit_of_measure,
166: si.primary_unit_of_measure

Line 169: po_distributions_all pod,

165: pol.unit_meas_lookup_code unit_of_measure,
166: si.primary_unit_of_measure
167: FROM po_line_locations_all pll,
168: po_lines_all pol,
169: po_distributions_all pod,
170: mtl_system_items si
171: WHERE pll.line_location_id = p_supply_demand_line_id
172: AND pll.po_line_id = pol.po_line_id
173: AND si.inventory_item_id(+) = pol.item_id