APPS.FV_SF224_TRANSACTIONS dependencies on PO_DISTRIBUTIONS

Line 5224: FROM po_distributions

5220: END IF;
5221: IF l_po_dist_id <> 0 THEN
5222: SELECT NVL(gl_encumbered_date,creation_date)
5223: INTO l_obligation_date
5224: FROM po_distributions
5225: WHERE po_distribution_id =l_po_dist_id;
5226: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
5228: 'Obligation Date is PO Date => ' || l_obligation_date);

Line 5442: FROM po_distributions

5438: (SELECT invoice_date
5439: FROM ap_invoices_all
5440: WHERE invoice_id = apid.parent_invoice_id)),
5441: (SELECT NVL(gl_encumbered_date,creation_date)
5442: FROM po_distributions
5443: WHERE po_distribution_id = apid.po_distribution_id))
5444: obligation_date,
5445: DECODE(apid.po_distribution_id,
5446: NULL,

Line 5456: FROM po_distributions

5452: WHERE invoice_id = apid.parent_invoice_id)),
5453: (SELECT segment1
5454: FROM po_headers
5455: WHERE po_header_id = (SELECT po_header_id
5456: FROM po_distributions
5457: WHERE po_distribution_id = apid.po_distribution_id)))
5458: obligation_number
5459: FROM
5460: ap_checks_all apc,