APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 3899: po_req_distributions_all prda,

3895: prla.line_location_id,
3896: prda.distribution_id
3897: FROM po_change_requests pcr,
3898: po_requisition_lines_all prla,
3899: po_req_distributions_all prda,
3900: po_line_locations_all plla
3901: WHERE document_header_id= p_po_header_id_csr
3902: AND request_status='BUYER_APP'
3903: AND change_active_flag='Y'

Line 3963: po_req_distributions_all prda,

3959: prla.line_location_id,
3960: prda.distribution_id
3961: FROM po_change_requests pcr,
3962: po_requisition_lines_all prla,
3963: po_req_distributions_all prda,
3964: po_line_locations_all plla
3965: WHERE pcr.po_release_id= p_po_release_id_csr
3966: AND request_status='BUYER_APP'
3967: AND change_active_flag='Y'

Line 4025: l_req_distribution_id po_req_distributions_all.distribution_id%type ;

4021: l_request_reason po_change_requests.request_reason%type ;
4022: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;
4023: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;
4024: l_line_location_id po_requisition_lines_all.line_location_id%type ;
4025: l_req_distribution_id po_req_distributions_all.distribution_id%type ;
4026: l_change_table PO_REQ_CHANGE_TABLE;
4027: l_cancel_table PO_REQ_CANCEL_TABLE:=null;
4028: l_rec_count number :=0;
4029: l_req_hdr_id number;