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_QUANTITIES_S dependencies on PO_LINES

Line 727: po_lines_all pl --

723: x_qty_rcv_exception_code,
724: x_item_id,
725: x_po_uom
726: FROM po_line_locations_all pll, --
727: po_lines_all pl --
728: WHERE pll.line_location_id = p_line_location_id
729: AND pll.po_line_id = pl.po_line_id;
730:
731: x_progress := '010';

Line 923: po_lines_all pl --

919: x_amount_cancelled,
920: x_qty_rcv_tolerance,
921: x_qty_rcv_exception_code
922: FROM po_line_locations_all pll, --
923: po_lines_all pl --
924: WHERE pll.line_location_id = p_line_location_id
925: AND pll.po_line_id = pl.po_line_id;
926:
927: x_progress := '010';

Line 2582: pol.UNIT_MEAS_LOOKUP_CODE, -- should get it from po_lines actually

2578: select (pod.QUANTITY_ORDERED - nvl(pod.QUANTITY_DELIVERED,0) -
2579: nvl(pod.QUANTITY_CANCELLED,0)) qty,
2580: (poll.quantity - nvl(poll.quantity_received,0) -
2581: nvl(poll.quantity_cancelled,0)) qty_rcvd,
2582: pol.UNIT_MEAS_LOOKUP_CODE, -- should get it from po_lines actually
2583: pol.item_id,
2584: 1 + (nvl(poll.qty_rcv_tolerance,0)/100), -- 1337787
2585: nvl(poll.quantity,0),
2586: nvl(poll.quantity_received,0),

Line 2598: po_lines_all pol --

2594: x_qty_received,
2595: x_qty_cancelled
2596: from po_distributions_all pod, --
2597: po_line_locations_all poll, --
2598: po_lines_all pol --
2599: where pod.line_location_id = poll.line_location_id
2600: and pod.po_distribution_id = p_po_distribution_id
2601: and pod.po_line_id = pol.po_line_id;
2602:

Line 2752: po_lines_all pol --

2748: x_amt_received,
2749: x_amt_cancelled
2750: from po_distributions_all pod, --
2751: po_line_locations_all poll, --
2752: po_lines_all pol --
2753: where pod.line_location_id = poll.line_location_id
2754: and pod.po_distribution_id = p_po_distribution_id
2755: and pod.po_line_id = pol.po_line_id;
2756:

Line 3062: PO_LINES PL

3058: PL.UNIT_MEAS_LOOKUP_CODE
3059: INTO x_item_id,
3060: x_po_uom
3061: FROM PO_LINE_LOCATIONS PLL,
3062: PO_LINES PL
3063: WHERE PLL.LINE_LOCATION_ID = p_line_location_id AND
3064: PLL.PO_LINE_ID = PL.PO_LINE_ID;
3065:
3066: x_progress := '010';

Line 3454: po_lines_all pol --

3450: l_qty_received,
3451: l_qty_cancelled
3452: from po_distributions_all pod, --
3453: po_line_locations_all poll, --
3454: po_lines_all pol --
3455: where pod.line_location_id = poll.line_location_id
3456: and pod.po_distribution_id = p_distribution_id
3457: and pod.po_line_id = pol.po_line_id;
3458: