DBA Data[Home] [Help]

APPS.POS_REVISION_DIFFERENCES dependencies on PO_LINE_LOCATIONS_ALL

Line 1127: FROM po_price_differentials_archive pdiff1,po_line_locations_all pll

1123: PDIFF1.CREATION_DATE ,
1124: PDIFF1.LAST_UPDATED_BY ,
1125: PDIFF1.LAST_UPDATE_DATE ,
1126: PDIFF1.LAST_UPDATE_LOGIN
1127: FROM po_price_differentials_archive pdiff1,po_line_locations_all pll
1128: WHERE
1129: pll.po_header_id = current_header_id and
1130: pll.line_location_id = pdiff1.entity_id and
1131: revision_num = (

Line 1134: po_line_locations_all pll2

1130: pll.line_location_id = pdiff1.entity_id and
1131: revision_num = (
1132: SELECT MAX( pdiff2.revision_num )
1133: FROM po_price_differentials_archive pdiff2,
1134: po_line_locations_all pll2
1135: WHERE
1136: pll2.po_header_id = current_header_id and
1137: pll2.line_location_id = pdiff2.entity_id and
1138: pdiff2.entity_type in ('PRICE BREAK') and