APPS.FV_SF224_TRANSACTIONS dependencies on PO_DISTRIBUTIONS

Line 5362: FROM po_distributions_all

5358: END IF;
5359: IF l_po_dist_id <> 0 THEN
5360: SELECT NVL(gl_encumbered_date,creation_date)
5361: INTO l_obligation_date
5362: FROM po_distributions_all
5363: WHERE po_distribution_id =l_po_dist_id;
5364: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
5366: 'Obligation Date is PO Date => ' || l_obligation_date);

Line 5586: FROM po_distributions

5582: (SELECT invoice_date
5583: FROM ap_invoices_all
5584: WHERE invoice_id = apid.parent_invoice_id)),
5585: (SELECT NVL(gl_encumbered_date,creation_date)
5586: FROM po_distributions
5587: WHERE po_distribution_id = apid.po_distribution_id))
5588: obligation_date,
5589: DECODE(apid.po_distribution_id,
5590: NULL,

Line 5600: FROM po_distributions

5596: WHERE invoice_id = apid.parent_invoice_id)),
5597: (SELECT segment1
5598: FROM po_headers
5599: WHERE po_header_id = (SELECT po_header_id
5600: FROM po_distributions
5601: WHERE po_distribution_id = apid.po_distribution_id)))
5602: obligation_number
5603: FROM
5604: ap_checks_all apc,