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.JAI_PO_CMN_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 514: FROM Po_Line_Locations_All

510: Qty_tab v_Qty_Tab;
511:
512: CURSOR Fetch_Qty_Cur IS
513: SELECT Quantity, Line_Location_Id
514: FROM Po_Line_Locations_All
515: WHERE Po_Header_Id = p_header_id
516: AND Po_Line_Id = v_po_line_id
517: and SYSDATE between nvl(start_date, SYSDATE) and nvl(end_date, SYSDATE) -- cbabu for Bug# 2740918
518: ORDER BY Quantity;

Line 533: FROM Po_Line_Locations_All

529: WHERE Po_Line_Id = p_line_id;
530:
531: CURSOR Fetch_Cum_Qty_Cur IS
532: SELECT SUM( Quantity )
533: FROM Po_Line_Locations_All
534: WHERE Po_Line_Id = v_po_line_id;
535:
536: CURSOR Chk_Line_Loc_Cur IS
537: SELECT COUNT( * )

Line 538: FROM Po_Line_Locations_All

534: WHERE Po_Line_Id = v_po_line_id;
535:
536: CURSOR Chk_Line_Loc_Cur IS
537: SELECT COUNT( * )
538: FROM Po_Line_Locations_All
539: WHERE Po_Line_Id = v_po_line_id;
540:
541: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.locate_source_line';
542: