DBA Data[Home] [Help]

APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_PRICE_DIFFERENTIALS_ARCHIVE

Line 1380: po_price_differentials_archive pdfa,

1376:
1377: SELECT 'Y'
1378: INTO x_different
1379: FROM po_price_differentials pdf,
1380: po_price_differentials_archive pdfa,
1381: po_lines_all pol
1382: WHERE pol.po_header_id = p_doc_id
1383: AND pol.po_line_id = pdf.entity_id
1384: AND pdf.entity_type in ('PO LINE', 'BLANKET LINE')

Line 1415: po_price_differentials_archive pdfa,

1411:
1412: SELECT 'Y'
1413: INTO x_different
1414: FROM po_price_differentials pdf,
1415: po_price_differentials_archive pdfa,
1416: po_line_locations_all poll
1417: WHERE poll.po_header_id = p_doc_id
1418: AND poll.line_location_id = pdf.entity_id
1419: AND pdf.entity_type = 'PRICE BREAK'