APPS.PO_POXDLPDT_XMLP_PKG dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 698: FND_DOCUMENTS_SHORT_TEXT

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

Line 724: FND_DOCUMENTS_SHORT_TEXT

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

Line 750: FND_DOCUMENTS_SHORT_TEXT

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

Line 776: FND_DOCUMENTS_SHORT_TEXT

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

Line 802: FND_DOCUMENTS_SHORT_TEXT

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

Line 828: FND_DOCUMENTS_SHORT_TEXT

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

Line 854: FND_DOCUMENTS_SHORT_TEXT

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

Line 880: FND_DOCUMENTS_SHORT_TEXT

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