APPS.PO_VAL_HEADERS dependencies on PO_LINES_GT

Line 1326: PO_LINES_GT LINE

1322: , l_message_name
1323: , SUBSTR(l_linemsg || c_delim || TO_CHAR(LINE.line_num) || c_delim
1324: || l_text,1,240)
1325: FROM
1326: PO_LINES_GT LINE
1327: , PO_HEADERS_GT HEADER
1328: WHERE
1329: LINE.expiration_date < HEADER.start_date
1330: OR LINE.expiration_date > HEADER.end_date

Line 1374: , PO_LINES_GT LINE

1370: || TO_CHAR(PRICE_BREAK.shipment_num) -- TODO: Need token from PM
1371: || l_text,1,240)
1372: FROM
1373: PO_LINE_LOCATIONS_ALL PRICE_BREAK
1374: , PO_LINES_GT LINE
1375: , PO_HEADERS_GT HEADER
1376: WHERE
1377: PRICE_BREAK.po_line_id = LINE.po_line_id
1378: AND PRICE_BREAK.start_date > HEADER.end_date

Line 1422: , PO_LINES_GT LINE

1418: || TO_CHAR(PRICE_BREAK.shipment_num) -- TODO: Need token from PM
1419: || l_text,1,240)
1420: FROM
1421: PO_LINE_LOCATIONS_ALL PRICE_BREAK
1422: , PO_LINES_GT LINE
1423: , PO_HEADERS_GT HEADER
1424: WHERE
1425: PRICE_BREAK.po_line_id = LINE.po_line_id
1426: AND PRICE_BREAK.start_date < HEADER.start_date

Line 1470: , PO_LINES_GT LINE

1466: || TO_CHAR(PRICE_BREAK.shipment_num) -- TODO: Need token from PM
1467: || l_text,1,240)
1468: FROM
1469: PO_LINE_LOCATIONS_ALL PRICE_BREAK
1470: , PO_LINES_GT LINE
1471: , PO_HEADERS_GT HEADER
1472: WHERE
1473: PRICE_BREAK.po_line_id = LINE.po_line_id
1474: AND PRICE_BREAK.end_date > HEADER.end_date

Line 1518: , PO_LINES_GT LINE

1514: || TO_CHAR(PRICE_BREAK.shipment_num) -- TODO: Need token from PM
1515: || l_text,1,240)
1516: FROM
1517: PO_LINE_LOCATIONS_ALL PRICE_BREAK
1518: , PO_LINES_GT LINE
1519: , PO_HEADERS_GT HEADER
1520: WHERE
1521: PRICE_BREAK.po_line_id = LINE.po_line_id
1522: AND PRICE_BREAK.end_date < HEADER.start_date