APPS.PO_RCOTOLERANCE_PVT dependencies on PO_REQUISITION_LINES

Line 40: po_requisition_lines prl

36: prd.distribution_id)),
37: 0)
38: INTO l_new_line_qty
39: FROM po_req_distributions prd,
40: po_requisition_lines prl
41: WHERE prl.requisition_header_id = p_req_id
42: AND prl.requisition_line_id = p_req_line_id
43: AND prl.requisition_line_id = prd.requisition_line_id
44: AND nvl(prl.cancel_flag, 'N') = 'N'

Line 651: PO_REQUISITION_LINES_ALL PRL

647: FROM dual
648: WHERE EXISTS (SELECT 'N' FROM (
649: SELECT PRL.UNIT_PRICE AS UNIT_PRICE, PRL.QUANTITY AS QUANTITY,PCR.NEW_QUANTITY AS NEW_QUANTITY
650: FROM PO_CHANGE_REQUESTS PCR,
651: PO_REQUISITION_LINES_ALL PRL
652: WHERE PCR.CHANGE_REQUEST_GROUP_ID = p_reqgrp_id
653: AND PCR.ACTION_TYPE = 'MODIFICATION'
654: AND PCR.REQUEST_STATUS NOT IN ('ACCEPTED',
655: 'REJECTED')

Line 680: po_requisition_lines_all prl,

676: FROM dual
677: WHERE EXISTS (SELECT 'N'
678: FROM po_change_requests pcr,
679: po_change_requests pcr1,
680: po_requisition_lines_all prl,
681: po_req_distributions_all prd
682: WHERE prd.requisition_line_id = prl.requisition_line_id
683: AND pcr.change_request_group_id = p_reqgrp_id
684: AND pcr.action_type (+ ) = 'MODIFICATION'

Line 748: po_requisition_lines_all prl,

744: l_tolerances_tbl(tol_reqtotal_amt_ind).max_decrement)
745: INTO l_return_val
746: FROM po_change_requests pcr,
747: po_change_requests pcr1,
748: po_requisition_lines_all prl,
749: po_req_distributions_all prd
750: WHERE prl.requisition_line_id = prd.requisition_line_id
751: AND pcr.change_request_group_id (+ ) = p_reqgrp_id
752: AND pcr.action_type (+ ) = 'MODIFICATION'