APPS.POS_ACK_PO dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 721: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

717: AND pll.po_release_id is null
718: AND pll.line_location_id= p_line_location_id
719: AND pll.promised_date is null;
720:
721: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
722: SET plla.promised_date = plla.need_by_date,
723: plla.last_update_date = sysdate,
724: plla.last_updated_by = p_user_id
725: WHERE plla.po_header_id = p_po_header_id

Line 730: FROM po_line_locations_archive_all plla2

726: AND plla.po_release_id is null
727: AND plla.line_location_id = p_line_location_id
728: AND plla.promised_date is null
729: AND plla.revision_num = (SELECT max(plla2.revision_num)
730: FROM po_line_locations_archive_all plla2
731: WHERE plla2.line_location_id = plla.line_location_id
732: AND plla.revision_num <= p_revision_num);
733: ELSE
734:

Line 752: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

748: AND ((nvl(pll.closed_code, 'OPEN') = 'OPEN' and
749: nvl(pll.consigned_flag, 'N') = 'N') OR
750: (pll.closed_code = 'CLOSED FOR INVOICE' and pll.consigned_flag = 'Y'));
751:
752: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
753: SET plla.promised_date = plla.need_by_date,
754: plla.last_update_date = sysdate,
755: plla.last_updated_by = p_user_id
756: WHERE plla.po_header_id = p_po_header_id

Line 759: FROM po_line_locations_archive_all plla2

755: plla.last_updated_by = p_user_id
756: WHERE plla.po_header_id = p_po_header_id
757: AND plla.promised_date is null
758: AND plla.revision_num = (SELECT max(plla2.revision_num)
759: FROM po_line_locations_archive_all plla2
760: WHERE plla2.line_location_id = plla.line_location_id
761: AND plla.revision_num <= p_revision_num)
762: /* AND exists (
763: SELECT 1

Line 789: UPDATE po_line_locations_archive_all plla

785: AND pll.line_location_id= p_line_location_id
786: AND pll.po_release_id = p_po_release_id
787: AND pll. promised_date is null;
788:
789: UPDATE po_line_locations_archive_all plla
790: SET plla.promised_date = plla.need_by_date,
791: plla.last_update_date = sysdate,
792: plla.last_updated_by = p_user_id
793: WHERE plla.po_header_id= p_po_header_id

Line 798: FROM po_line_locations_archive_all plla2

794: AND plla.line_location_id= p_line_location_id
795: AND plla.po_release_id = p_po_release_id
796: AND plla. promised_date is null
797: AND plla.revision_num = (SELECT max(plla2.revision_num)
798: FROM po_line_locations_archive_all plla2
799: WHERE plla2.line_location_id = plla.line_location_id
800: AND plla.revision_num <= p_revision_num);
801:
802: ELSE

Line 821: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

817: AND pa.po_line_location_id = PLL.line_location_id ) */
818: AND nvl(pll.cancel_flag, 'N') = 'N'
819: AND ((nvl(pll.closed_code, 'OPEN') = 'OPEN' AND (nvl(pll.consigned_flag, 'N') = 'N')) OR (pll.closed_code = 'CLOSED FOR INVOICE' AND pll.consigned_flag = 'Y'));
820:
821: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
822: SET plla.promised_date =need_by_date,
823: plla.last_update_date = sysdate,
824: plla.last_updated_by = p_user_id
825: WHERE plla.po_header_id = p_po_header_id

Line 829: FROM po_line_locations_archive_all plla2

825: WHERE plla.po_header_id = p_po_header_id
826: AND plla.po_release_id = p_po_release_id
827: AND plla.promised_date is null
828: AND plla.revision_num = (SELECT max(plla2.revision_num)
829: FROM po_line_locations_archive_all plla2
830: WHERE plla2.line_location_id = plla.line_location_id
831: AND plla.revision_num <= p_revision_num)
832: /* AND exists (
833: SELECT 1