DBA Data[Home] [Help]

APPS.PO_PAR_REQ_CREATE_UTIL dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 237: FROM po_distributions_draft_all

233: draft_id,
234: po_header_id,
235: destination_type_code,
236: destination_organization_id
237: FROM po_distributions_draft_all
238: WHERE po_line_id = L_po_line_id_tbl(i)
239: AND draft_id = p_par_draft_id
240: AND po_header_id = p_po_header_id
241: AND ROWNUM = 1) pldor

Line 337: FROM po_distributions_draft_all PDD

333: AND old_amount_ordered IS NULL THEN NULL
334: ELSE Nvl(old_amount_ordered, 0) - Nvl(amount_ordered, 0)
335: END ) AMOUNT_FUNDED,
336: funded_value
337: FROM po_distributions_draft_all PDD
338: WHERE PDD.po_header_id = p_po_header_id
339: AND change_status = 'NEW'
340: AND PDD.draft_id = p_par_draft_id
341: AND PDD.po_line_id = L_po_line_id_tbl(i);