DBA Data[Home] [Help]

APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 4016: po_req_distributions_all prda,

4012: prla.line_location_id,
4013: prda.distribution_id
4014: FROM po_change_requests pcr,
4015: po_requisition_lines_all prla,
4016: po_req_distributions_all prda,
4017: po_line_locations_all plla
4018: WHERE document_header_id= p_po_header_id_csr
4019: AND request_status='BUYER_APP'
4020: AND change_active_flag='Y'

Line 4080: po_req_distributions_all prda,

4076: prla.line_location_id,
4077: prda.distribution_id
4078: FROM po_change_requests pcr,
4079: po_requisition_lines_all prla,
4080: po_req_distributions_all prda,
4081: po_line_locations_all plla
4082: WHERE pcr.po_release_id= p_po_release_id_csr
4083: AND request_status='BUYER_APP'
4084: AND change_active_flag='Y'

Line 4142: l_req_distribution_id po_req_distributions_all.distribution_id%type ;

4138: l_request_reason po_change_requests.request_reason%type ;
4139: l_requisition_line_id po_requisition_lines_all.requisition_line_id%type ;
4140: l_requisition_header_id po_requisition_lines_all.requisition_header_id%type ;
4141: l_line_location_id po_requisition_lines_all.line_location_id%type ;
4142: l_req_distribution_id po_req_distributions_all.distribution_id%type ;
4143: l_change_table PO_REQ_CHANGE_TABLE;
4144: l_cancel_table PO_REQ_CANCEL_TABLE:=null;
4145: l_rec_count number :=0;
4146: l_req_hdr_id number;