DBA Data[Home] [Help]

APPS.POS_REVISION_DIFFERENCES dependencies on PO_LINES_ALL

Line 1009: FROM po_price_differentials_archive pdiff1,po_lines_all pol

1005: PDIFF1.CREATION_DATE ,
1006: PDIFF1.LAST_UPDATED_BY ,
1007: PDIFF1.LAST_UPDATE_DATE ,
1008: PDIFF1.LAST_UPDATE_LOGIN
1009: FROM po_price_differentials_archive pdiff1,po_lines_all pol
1010: WHERE
1011: pol.po_header_id = current_header_id and
1012: pol.po_line_id = pdiff1.entity_id and
1013: pol.revision_num = (

Line 1016: po_lines_all pol2

1012: pol.po_line_id = pdiff1.entity_id and
1013: pol.revision_num = (
1014: SELECT MAX( pdiff2.revision_num )
1015: FROM po_price_differentials_archive pdiff2,
1016: po_lines_all pol2
1017: WHERE
1018: pol2.po_header_id = current_header_id and
1019: pol2.po_line_id = pdiff2.entity_id and
1020: pdiff2.entity_type in ('PO LINE','BLANKET LINE') and