DBA Data[Home] [Help]

APPS.PO_PRICE_BREAK_S dependencies on PO_HEADERS

Line 42: FROM po_headers poh

38: , poll.price_override
39: , decode( poll.line_location_id,
40: null, pol.unit_meas_lookup_code,
41: poll.unit_meas_lookup_code)
42: FROM po_headers poh
43: , po_lines pol
44: , po_line_locations poll
45: WHERE poh.po_header_id = source_document_header_id
46: and poh.po_header_id = pol.po_header_id

Line 97: FROM po_headers poh

93: pol.unit_price)
94: , decode( poll.line_location_id,
95: null, pol.unit_meas_lookup_code,
96: poll.unit_meas_lookup_code)
97: FROM po_headers poh
98: , po_lines pol
99: , po_line_locations poll
100: WHERE poh.po_header_id = source_document_header_id
101: and poh.po_header_id = pol.po_header_id

Line 152: po_headers poh

148: round(pol.unit_price * decode(poh.rate, 0, 1, null, 1, poh.rate), 5 )
149: INTO base_price,
150: currency_price
151: FROM po_lines pol,
152: po_headers poh
153: WHERE pol.po_header_id = poh.po_header_id
154: AND pol.po_header_id = source_document_header_id
155: AND pol.line_num = source_document_line_num;
156: