APPS.PO_NEGOTIATIONS4_PVT dependencies on PO_LINE_TYPES_B

Line 425: , po_line_types_b PLT

421: SET ( PRS.record_status
422: , PRS.new_req_line_id ) = ( SELECT 'T'
423: , PRL.requisition_line_id
424: FROM po_requisition_lines_all PRL
425: , po_line_types_b PLT
426: WHERE PRL.requisition_line_id = PRS.requisition_line_id
427: AND PRL.line_type_id = PLT.line_type_id
428: AND PLT.order_type_lookup_code IN ('RATE','FIXED PRICE')
429: )

Line 639: -- po_line_types_b.

635: --
636: -- For Amount based lines, new req line should be created only if profile
637: -- PO_RECRT_POST_AWRD_AMT_REQ_BAL value is Y.
638: -- Added join conditions with tables po_requisition_lines_all and
639: -- po_line_types_b.
640: INSERT INTO po_req_split_lines_gt
641: ( auction_header_id,
642: bid_number,
643: bid_line_number,

Line 666: po_line_types_b plt

662: NULL,
663: 'N'
664: FROM po_req_split_lines_gt prsl,
665: po_requisition_lines_all prl,
666: po_line_types_b plt
667: WHERE prsl.total_alloc_req_line_qty < prsl.requisition_line_qty
668: AND prsl.record_status NOT IN ('I','T') --
669: AND prsl.bid_number = prsl.min_bid_number
670: AND prsl.requisition_line_id = prl.requisition_line_id