DBA Data[Home] [Help]

APPS.PO_AME_SETUP_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 128: FROM po_req_distributions_all

124: l_sob NUMBER;
125:
126:
127: cursor c1(l_distribution_id in NUMBER) is SELECT code_combination_id, set_of_books_id
128: FROM po_req_distributions_all
129: WHERE distribution_id= l_distribution_id;
130:
131: cursor c2(l_distribution_id in NUMBER) is SELECT code_combination_id, set_of_books_id
132: FROM po_distributions_merge_v

Line 317: PO_REQ_DISTRIBUTIONS_ALL PORD, --

313: PORL.requisition_header_id,PORL.requisition_line_id,
314: PORD.distribution_id))
315: into l_req_total
316: FROM
317: PO_REQ_DISTRIBUTIONS_ALL PORD, --
318: PO_REQUISITION_LINES PORL
319: WHERE PORL.requisition_header_id = ReqHeaderId
320: AND PORL.requisition_line_id = PORD.requisition_line_id
321: AND nvl(PORL.cancel_flag, 'N') = 'N'