APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 2492: FROM PO_DISTRIBUTIONS_ALL POD,

2488: ,POD.CHANGE_IN_FUNDED_VALUE
2489: ,POD.USSGL_TRANSACTION_CODE
2490: --
2491: ,POD.clm_payment_sequence_num --
2492: FROM PO_DISTRIBUTIONS_ALL POD,
2493: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
2494: WHERE ((p_document_type = 'RELEASE' AND
2495: POD.po_release_id = p_document_id) OR
2496: (p_document_type <> 'RELEASE' AND -- Bug 3210749

Line 6845: l_from_po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;

6841: l_from_po_line_id PO_LINES_ALL.po_line_id%TYPE;
6842: l_to_po_line_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
6844: l_to_line_location_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6845: l_from_po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
6846: l_to_po_distribution_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6847:
6848: -- Cursor definitions:
6849:

Line 6864: FROM PO_DISTRIBUTIONS_ALL

6860: ORDER BY shipment_num;
6861:
6862: CURSOR po_distribution_cursor(p_line_location_id po_distributions.line_location_id%TYPE) IS
6863: SELECT po_distribution_id
6864: FROM PO_DISTRIBUTIONS_ALL
6865: WHERE line_location_id = p_line_location_id
6866: ORDER BY distribution_num;
6867:
6868: BEGIN