DBA Data[Home] [Help]

APPS.POS_COMPLEX_WORK_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 360: PO_LINES_ARCHIVE_ALL POL

356: select ROUND(DECODE(PLL.matching_basis,
357: 'AMOUNT', (NVL(PLL.amount, 0)/POL.amount)*100,
358: 'QUANTITY', (NVL(PLL.price_override, 0)/POL.unit_price)*100))
359: from PO_LINE_LOCATIONS_ARCHIVE_ALL PLL,
360: PO_LINES_ARCHIVE_ALL POL
361: where PLL.po_line_id = POL.po_line_id
362: and PLL.line_location_id = p_po_line_location_id
363: and PLL.payment_type = 'MILESTONE'
364: and PLL.latest_external_flag ='Y'