APPS.POS_ACK_PO dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 722: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

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

Line 731: FROM po_line_locations_archive_all plla2

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

Line 753: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

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

Line 760: FROM po_line_locations_archive_all plla2

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

Line 790: UPDATE po_line_locations_archive_all plla

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

Line 799: FROM po_line_locations_archive_all plla2

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

Line 822: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA

818: AND pa.po_line_location_id = PLL.line_location_id ) */
819: AND nvl(pll.cancel_flag, 'N') = 'N'
820: 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'));
821:
822: UPDATE PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
823: SET plla.promised_date =need_by_date,
824: plla.last_update_date = sysdate,
825: plla.last_updated_by = p_user_id
826: WHERE plla.po_header_id = p_po_header_id

Line 830: FROM po_line_locations_archive_all plla2

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