APPS.PO_VAL_HEADERS dependencies on PO_LINES_GT

Line 1959: PO_LINES_GT LINE

1955: , l_message_name
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

Line 2007: , PO_LINES_GT LINE

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

Line 2055: , PO_LINES_GT LINE

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

Line 2103: , PO_LINES_GT LINE

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

Line 2151: , PO_LINES_GT LINE

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