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

Line 2006: PO_LINE_LOCATIONS_ALL PRICE_BREAK

2002: , SUBSTR(l_linemsg || c_delim || TO_CHAR(LINE.line_num) || c_delim
2003: || TO_CHAR(PRICE_BREAK.shipment_num) -- TODO: Need token from PM
2004: || l_text,1,240)
2005: FROM
2006: PO_LINE_LOCATIONS_ALL PRICE_BREAK
2007: , PO_LINES_GT LINE
2008: , PO_HEADERS_GT HEADER
2009: WHERE
2010: PRICE_BREAK.po_line_id = LINE.po_line_id

Line 2054: PO_LINE_LOCATIONS_ALL PRICE_BREAK

2050: , SUBSTR(l_linemsg || c_delim || TO_CHAR(LINE.line_num) || c_delim
2051: || TO_CHAR(PRICE_BREAK.shipment_num) -- TODO: Need token from PM
2052: || l_text,1,240)
2053: FROM
2054: PO_LINE_LOCATIONS_ALL PRICE_BREAK
2055: , PO_LINES_GT LINE
2056: , PO_HEADERS_GT HEADER
2057: WHERE
2058: PRICE_BREAK.po_line_id = LINE.po_line_id

Line 2102: PO_LINE_LOCATIONS_ALL PRICE_BREAK

2098: , SUBSTR(l_linemsg || c_delim || TO_CHAR(LINE.line_num) || c_delim
2099: || TO_CHAR(PRICE_BREAK.shipment_num) -- TODO: Need token from PM
2100: || l_text,1,240)
2101: FROM
2102: PO_LINE_LOCATIONS_ALL PRICE_BREAK
2103: , PO_LINES_GT LINE
2104: , PO_HEADERS_GT HEADER
2105: WHERE
2106: PRICE_BREAK.po_line_id = LINE.po_line_id

Line 2150: PO_LINE_LOCATIONS_ALL PRICE_BREAK

2146: , SUBSTR(l_linemsg || c_delim || TO_CHAR(LINE.line_num) || c_delim
2147: || TO_CHAR(PRICE_BREAK.shipment_num) -- TODO: Need token from PM
2148: || l_text,1,240)
2149: FROM
2150: PO_LINE_LOCATIONS_ALL PRICE_BREAK
2151: , PO_LINES_GT LINE
2152: , PO_HEADERS_GT HEADER
2153: WHERE
2154: PRICE_BREAK.po_line_id = LINE.po_line_id

Line 2457: FROM PO_LINE_LOCATIONS_ALL

2453: FROM DUAL
2454: WHERE p_mod_eff_date_tbl(i) is not NULL
2455: AND p_mod_eff_date_tbl(i) > (
2456: SELECT min(nvl(need_by_date, p_mod_eff_date_tbl(i)+1))
2457: FROM PO_LINE_LOCATIONS_ALL
2458: WHERE po_header_id = p_header_id_tbl(i));
2459:
2460: IF (SQL%ROWCOUNT > 0) THEN
2461: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

Line 2581: FROM PO_LINE_LOCATIONS_ALL

2577: FROM DUAL
2578: WHERE nvl(p_control_action_tbl(i), '*') = 'CANCEL'
2579: AND not exists
2580: (SELECT 'Y'
2581: FROM PO_LINE_LOCATIONS_ALL
2582: WHERE po_header_id = p_header_id_tbl(i)
2583: AND quantity > quantity_received);
2584:
2585: IF (SQL%ROWCOUNT > 0) THEN