DBA Data[Home] [Help]

APPS.PO_PRICE_BREAK_S dependencies on PO_LINES

Line 43: , po_lines pol

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
47: and pol.line_num = source_document_line_num

Line 98: , po_lines pol

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
102: and pol.line_num = source_document_line_num

Line 151: FROM po_lines pol,

147: SELECT pol.unit_price,
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;