DBA Data[Home] [Help]

APPS.PO_AME_SETUP_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 132: FROM po_req_distributions_all

128: /* find set of book id and code combination id from distribution */
129:
130: SELECT code_combination_id, set_of_books_id
131: INTO l_ccid, l_sob
132: FROM po_req_distributions_all
133: WHERE distribution_id= distributionId;
134:
135: /* find chart of account id from set of book */
136: SELECT chart_of_accounts_id

Line 215: PO_REQ_DISTRIBUTIONS_ALL PORD, --

211: PORL.requisition_header_id,PORL.requisition_line_id,
212: PORD.distribution_id))
213: into l_req_total
214: FROM
215: PO_REQ_DISTRIBUTIONS_ALL PORD, --
216: PO_REQUISITION_LINES PORL
217: WHERE PORL.requisition_header_id = ReqHeaderId
218: AND PORL.requisition_line_id = PORD.requisition_line_id
219: AND nvl(PORL.cancel_flag, 'N') = 'N'