APPS.PO_VAL_HEADERS dependencies on PO_HEADERS_GT

Line 1960: , PO_HEADERS_GT HEADER

1956: , SUBSTR(l_linemsg || c_delim || TO_CHAR(LINE.line_num) || c_delim
1957: || l_text,1,240)
1958: FROM
1959: PO_LINES_GT LINE
1960: , PO_HEADERS_GT HEADER
1961: WHERE
1962: LINE.expiration_date < HEADER.start_date
1963: OR LINE.expiration_date > HEADER.end_date
1964: ;

Line 2008: , PO_HEADERS_GT HEADER

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
2011: AND PRICE_BREAK.start_date > HEADER.end_date
2012: ;

Line 2056: , PO_HEADERS_GT HEADER

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
2059: AND PRICE_BREAK.start_date < HEADER.start_date
2060: ;

Line 2104: , PO_HEADERS_GT HEADER

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
2107: AND PRICE_BREAK.end_date > HEADER.end_date
2108: ;

Line 2152: , PO_HEADERS_GT HEADER

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
2155: AND PRICE_BREAK.end_date < HEADER.start_date
2156: ;