694: SELECT
695: SHORT_TEXT
696: INTO SHORT_NOTE
697: FROM
698: FND_DOCUMENTS_SHORT_TEXT
699: WHERE MEDIA_ID = ITEM_NOTE_MEDIA_ID;
700: RETURN SHORT_NOTE;
701: ELSIF ITEM_NOTE_DATATYPE_ID = 2 THEN
702: SELECT
720: SELECT
721: SHORT_TEXT
722: INTO SHORT_NOTE
723: FROM
724: FND_DOCUMENTS_SHORT_TEXT
725: WHERE MEDIA_ID = LONG_NOTE_MEDIA_ID;
726: RETURN SHORT_NOTE;
727: ELSIF LONG_NOTE_DATATYPE_ID = 2 THEN
728: SELECT
746: SELECT
747: SHORT_TEXT
748: INTO SHORT_NOTE
749: FROM
750: FND_DOCUMENTS_SHORT_TEXT
751: WHERE MEDIA_ID = TRX_NOTE_MEDIA_ID;
752: RETURN SHORT_NOTE;
753: ELSIF TRX_NOTE_DATATYPE_ID = 2 THEN
754: SELECT
772: SELECT
773: SHORT_TEXT
774: INTO SHORT_NOTE
775: FROM
776: FND_DOCUMENTS_SHORT_TEXT
777: WHERE MEDIA_ID = PO_HEADER_NOTE_MEDIA_ID;
778: RETURN SHORT_NOTE;
779: ELSIF PO_HEADER_NOTE_DATATYPE_ID = 2 THEN
780: SELECT
798: SELECT
799: SHORT_TEXT
800: INTO SHORT_NOTE
801: FROM
802: FND_DOCUMENTS_SHORT_TEXT
803: WHERE MEDIA_ID = PO_LINE_NOTE_MEDIA_ID;
804: RETURN SHORT_NOTE;
805: ELSIF PO_LINE_NOTE_DATATYPE_ID = 2 THEN
806: SELECT
824: SELECT
825: SHORT_TEXT
826: INTO SHORT_NOTE
827: FROM
828: FND_DOCUMENTS_SHORT_TEXT
829: WHERE MEDIA_ID = REQ_HEADER_NOTE_MEDIA_ID;
830: RETURN SHORT_NOTE;
831: ELSIF REQ_HEADER_NOTE_DATATYPE_ID = 2 THEN
832: SELECT
850: SELECT
851: SHORT_TEXT
852: INTO SHORT_NOTE
853: FROM
854: FND_DOCUMENTS_SHORT_TEXT
855: WHERE MEDIA_ID = REQ_LINE_NOTE_MEDIA_ID;
856: RETURN SHORT_NOTE;
857: ELSIF REQ_LINE_NOTE_DATATYPE_ID = 2 THEN
858: SELECT
876: SELECT
877: SHORT_TEXT
878: INTO SHORT_NOTE
879: FROM
880: FND_DOCUMENTS_SHORT_TEXT
881: WHERE MEDIA_ID = SHIPMENT_NOTE_MEDIA_ID;
882: RETURN SHORT_NOTE;
883: ELSIF SHIPMENT_NOTE_DATATYPE_ID = 2 THEN
884: SELECT