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 407: delete po_distributions_all /Bug6632095: using base table instead of view /

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

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

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

Line 651: l_creation_date po_distributions_all.creation_date%TYPE;

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

Line 652: l_req_distribution_id po_distributions_all.req_distribution_id%TYPE;

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

Line 653: l_quantity_delivered po_distributions_all.quantity_delivered%TYPE;

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

Line 654: l_amount_delivered po_distributions_all.amount_delivered%TYPE;

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

Line 655: l_encumbered_flag po_distributions_all.encumbered_flag%TYPE;

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

Line 656: l_quantity_billed po_distributions_all.quantity_billed%TYPE;

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

Line 657: l_amount_billed po_distributions_all.amount_billed%TYPE;

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

Line 659: l_po_header_id po_distributions_all.po_header_id%TYPE;

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

Line 688: FROM po_distributions_all

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

Line 705: FROM po_distributions_all pod

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

Line 759: FROM po_distributions_all pod

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