eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DISTRIBUTIONS_SV dependencies on PO_DISTRIBUTIONS_ALL

Line 408: delete po_distributions_all /Bug6632095: using base table instead of view /

404:
405: x_progress := '010';
406: IF (X_delete_entity = 'RELEASE') THEN
407:
408: delete po_distributions_all /*Bug6632095: using base table instead of view */
409: where line_location_id in
410: (select line_location_id
411: from po_line_locations_all
412: where po_release_id = x_delete_id);

Line 433: DELETE PO_DISTRIBUTIONS_ALL /Bug6632095: using base table instead of view /

429:
430: --
431: --We can have encumbrance distributions tied to a BPA header.
432: --Allow distributions with distribution_type 'AGREEMENT' to be deleted.
433: DELETE PO_DISTRIBUTIONS_ALL /*Bug6632095: using base table instead of view */
434: WHERE po_header_id = x_delete_id
435: AND distribution_type in ('STANDARD', 'PLANNED', 'AGREEMENT');
436: --
437:

Line 652: l_creation_date po_distributions_all.creation_date%TYPE;

648: ,p_line_loc_id IN NUMBER
649: ,p_approved_date IN VARCHAR2
650: ,p_style_disp_name IN VARCHAR2
651: ,x_message_text OUT NOCOPY VARCHAR2) IS
652: l_creation_date po_distributions_all.creation_date%TYPE;
653: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
654: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
655: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;

Line 653: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;

649: ,p_approved_date IN VARCHAR2
650: ,p_style_disp_name IN VARCHAR2
651: ,x_message_text OUT NOCOPY VARCHAR2) IS
652: l_creation_date po_distributions_all.creation_date%TYPE;
653: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
654: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
655: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
657: l_quantity_billed po_distributions_all.quantity_billed%TYPE;

Line 654: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;

650: ,p_style_disp_name IN VARCHAR2
651: ,x_message_text OUT NOCOPY VARCHAR2) IS
652: l_creation_date po_distributions_all.creation_date%TYPE;
653: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
654: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
655: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
657: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
658: l_amount_billed po_distributions_all.amount_billed%TYPE;

Line 655: l_amount_delivered po_distributions_all.amount_delivered%TYPE;

651: ,x_message_text OUT NOCOPY VARCHAR2) IS
652: l_creation_date po_distributions_all.creation_date%TYPE;
653: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
654: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
655: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
657: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
658: l_amount_billed po_distributions_all.amount_billed%TYPE;
659: --BUG 5553581

Line 656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;

652: l_creation_date po_distributions_all.creation_date%TYPE;
653: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
654: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
655: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
657: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
658: l_amount_billed po_distributions_all.amount_billed%TYPE;
659: --BUG 5553581
660: l_po_header_id po_distributions_all.po_header_id%TYPE;

Line 657: l_quantity_billed po_distributions_all.quantity_billed%TYPE;

653: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;
654: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
655: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
657: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
658: l_amount_billed po_distributions_all.amount_billed%TYPE;
659: --BUG 5553581
660: l_po_header_id po_distributions_all.po_header_id%TYPE;
661: l_is_complex_work_po BOOLEAN;

Line 658: l_amount_billed po_distributions_all.amount_billed%TYPE;

654: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;
655: l_amount_delivered po_distributions_all.amount_delivered%TYPE;
656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
657: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
658: l_amount_billed po_distributions_all.amount_billed%TYPE;
659: --BUG 5553581
660: l_po_header_id po_distributions_all.po_header_id%TYPE;
661: l_is_complex_work_po BOOLEAN;
662: l_dummy NUMBER := 0;

Line 660: l_po_header_id po_distributions_all.po_header_id%TYPE;

656: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;
657: l_quantity_billed po_distributions_all.quantity_billed%TYPE;
658: l_amount_billed po_distributions_all.amount_billed%TYPE;
659: --BUG 5553581
660: l_po_header_id po_distributions_all.po_header_id%TYPE;
661: l_is_complex_work_po BOOLEAN;
662: l_dummy NUMBER := 0;
663: d_pos NUMBER := 0;
664: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_distribution';

Line 689: FROM po_distributions_all

685: l_amount_delivered,
686: l_encumbered_flag,
687: l_quantity_billed,
688: l_amount_billed
689: FROM po_distributions_all
690: WHERE po_distribution_id = p_po_distribution_id;
691:
692: l_is_complex_work_po := PO_COMPLEX_WORK_PVT.is_complex_work_po(l_po_header_id);
693:

Line 706: FROM po_distributions_all pod

702: ELSE
703: BEGIN --5553581
704: select po_distribution_id
705: into l_dummy
706: FROM po_distributions_all pod
707: WHERE pod.line_location_id = p_line_loc_id
708: AND pod.req_distribution_id = l_req_distribution_id;
709:
710: x_message_text := PO_CORE_S.get_translated_text('PO_PO_DEL_DIST_ONLINE_REQ_NA');

Line 760: FROM po_distributions_all pod

756: -- to delete the distribution
757: BEGIN
758: select po_distribution_id
759: into l_dummy
760: FROM po_distributions_all pod
761: WHERE pod.line_location_id = p_line_loc_id;
762:
763: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_DIST');
764: RAISE PO_CORE_S.G_EARLY_RETURN_EXC;