DBA Data[Home] [Help]

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PON_BACKING_REQUISITIONS

Line 130: FROM PON_BACKING_REQUISITIONS PB, PO_REQUISITION_LINES_ALL PRL

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
133: AND PB.requisition_line_id = PRL.requisition_line_id
134: AND PRL.blanket_po_header_id IS NOT NULL

Line 157: FROM PON_BACKING_REQUISITIONS PB, PO_REQUISITION_LINES_ALL PRL

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
160: AND PB.requisition_line_id = PRL.requisition_line_id
161: AND PRL.blanket_po_header_id IS NOT NULL