DBA Data[Home] [Help]

APPS.PO_RCOTOLERANCE_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 654: PO_REQUISITION_LINES_ALL PRL

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

Line 683: po_requisition_lines_all prl,

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

Line 751: po_requisition_lines_all prl,

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