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_DOCUMENT_TYPES_ALL_PKG dependencies on PO_DOCUMENT_TYPES_ALL_VL

Line 751: /* Changed table in query from PO_DOCUMENT_TYPES_ALL_B to PO_DOCUMENT_TYPES_ALL_VL

747: db_luby number; -- entity owner in db
748: db_ludate date; -- entity update date in db
749:
750: --Bug 6810625 Start
751: /* Changed table in query from PO_DOCUMENT_TYPES_ALL_B to PO_DOCUMENT_TYPES_ALL_VL
752: because table PO_DOCUMENT_TYPES_ALL_B doesnot contain TYPE_NAME Column.
753: This column is in table PO_DOCUMENT_TYPES_ALL_TL.
754: but view PO_DOCUMENT_TYPES_ALL_VL contains this column as its queries from both
755: the tables PO_DOCUMENT_TYPES_ALL_B and PO_DOCUMENT_TYPES_ALL_TL. */

Line 754: but view PO_DOCUMENT_TYPES_ALL_VL contains this column as its queries from both

750: --Bug 6810625 Start
751: /* Changed table in query from PO_DOCUMENT_TYPES_ALL_B to PO_DOCUMENT_TYPES_ALL_VL
752: because table PO_DOCUMENT_TYPES_ALL_B doesnot contain TYPE_NAME Column.
753: This column is in table PO_DOCUMENT_TYPES_ALL_TL.
754: but view PO_DOCUMENT_TYPES_ALL_VL contains this column as its queries from both
755: the tables PO_DOCUMENT_TYPES_ALL_B and PO_DOCUMENT_TYPES_ALL_TL. */
756:
757: --rec PO_DOCUMENT_TYPES_ALL_B%Rowtype; -- Bug6086648 FP:Bug 5985709
758: rec PO_DOCUMENT_TYPES_ALL_VL%Rowtype;

Line 758: rec PO_DOCUMENT_TYPES_ALL_VL%Rowtype;

754: but view PO_DOCUMENT_TYPES_ALL_VL contains this column as its queries from both
755: the tables PO_DOCUMENT_TYPES_ALL_B and PO_DOCUMENT_TYPES_ALL_TL. */
756:
757: --rec PO_DOCUMENT_TYPES_ALL_B%Rowtype; -- Bug6086648 FP:Bug 5985709
758: rec PO_DOCUMENT_TYPES_ALL_VL%Rowtype;
759: --End Bug 6810625
760:
761: begin
762:

Line 770: SELECT * into rec FROM PO_DOCUMENT_TYPES_ALL_VL

766: --End Bug6910423
767:
768: -- Bug6086648 FP:Bug 5985709. Query added to get the existing data.
769: -- Bug 6810625
770: SELECT * into rec FROM PO_DOCUMENT_TYPES_ALL_VL
771: where DOCUMENT_TYPE_CODE = X_DOCUMENT_TYPE_CODE
772: and DOCUMENT_SUBTYPE = X_DOCUMENT_SUBTYPE
773: and NVL(X_ORG_ID, -99) = NVL(ORG_ID, -99) ;
774: -- End Bug 6810625