APPS.PO_VAL_HEADERS dependencies on PO_HEADERS_GT

Line 1327: , PO_HEADERS_GT HEADER

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
1331: ;

Line 1375: , PO_HEADERS_GT HEADER

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
1379: ;

Line 1423: , PO_HEADERS_GT HEADER

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
1427: ;

Line 1471: , PO_HEADERS_GT HEADER

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
1475: ;

Line 1519: , PO_HEADERS_GT HEADER

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
1523: ;