DBA Data[Home] [Help]

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 128: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,

124: p_auction_header_id NUMBER
125: ) IS
126: SELECT PAIP.line_number,
127: PAV.*
128: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,
129: ( SELECT PB.auction_header_id, PB.line_number, blanket_po_header_id, blanket_po_line_num
130: FROM PON_BACKING_REQUISITIONS PB, PO_REQUISITION_LINES_ALL PRL
131: WHERE PB.auction_header_id = p_auction_header_id
132: AND PB.requisition_header_id = PRL.requisition_header_id

Line 155: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,

151: )
152: IS
153: SELECT PAIP.line_number,
154: PAVT.*
155: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP,
156: ( SELECT PB.auction_header_id, PB.line_number, blanket_po_header_id, blanket_po_line_num
157: FROM PON_BACKING_REQUISITIONS PB, PO_REQUISITION_LINES_ALL PRL
158: WHERE PB.auction_header_id = p_auction_header_id
159: AND PB.requisition_header_id = PRL.requisition_header_id