DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on PO_PRICE_DIFFERENTIALS

Line 230: FROM po_price_differentials

226: */ --
227:
228: CURSOR l_price_diff_csr ( p_req_line_id NUMBER ) IS
229: SELECT *
230: FROM po_price_differentials
231: WHERE entity_type = 'REQ LINE'
232: AND entity_id = p_req_line_id;
233: --
234: --

Line 656: IF ( PO_PRICE_DIFFERENTIALS_PVT.has_price_differentials

652: --
653:
654: -- Determine if this Requisition Line has Price Differentials.
655: --
656: IF ( PO_PRICE_DIFFERENTIALS_PVT.has_price_differentials
657: ( p_entity_type => 'REQ LINE'
658: , p_entity_id => x_req_line_id) --Bug 5841426
659: )
660: THEN

Line 1558: FROM po_price_differentials PD

1554: , PD.created_by
1555: , PD.last_update_date
1556: , PD.last_updated_by
1557: , PD.last_update_login
1558: FROM po_price_differentials PD
1559: , po_lines_all POL
1560: WHERE PD.entity_type = 'BLANKET LINE'
1561: AND PD.entity_id = POL.po_line_id
1562: AND POL.po_header_id = p_po_header_id;

Line 1594: FROM po_price_differentials PD

1590: , PD.created_by
1591: , PD.last_update_date
1592: , PD.last_updated_by
1593: , PD.last_update_login
1594: FROM po_price_differentials PD
1595: , po_lines_all POL
1596: , po_line_locations_all POLL
1597: WHERE PD.entity_type = 'PRICE BREAK'
1598: AND PD.entity_id = POLL.line_location_id