APPS.PO_RCOTOLERANCE_PVT dependencies on PO_REQUISITION_LINES_ALL

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'