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_INQ_SV dependencies on PO_DOCUMENT_TYPES_B

Line 138: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;

134:
135: is
136:
137: /* Start Bug 3336172 */
138: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;
139: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;
140: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;
141:
142: l_sec_level_tbl g_sec_level_tbl_type;

Line 139: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;

135: is
136:
137: /* Start Bug 3336172 */
138: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;
139: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;
140: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;
141:
142: l_sec_level_tbl g_sec_level_tbl_type;
143: l_doc_type_code_tbl g_doc_type_code_tbl_type;

Line 140: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;

136:
137: /* Start Bug 3336172 */
138: TYPE g_sec_level_tbl_type IS TABLE OF po_document_types_b.security_level_code%TYPE;
139: TYPE g_doc_type_code_tbl_type IS TABLE OF po_document_types_b.document_type_code%TYPE;
140: TYPE g_doc_subtype_tbl_type IS TABLE OF po_document_types_b.document_subtype%TYPE;
141:
142: l_sec_level_tbl g_sec_level_tbl_type;
143: l_doc_type_code_tbl g_doc_type_code_tbl_type;
144: l_doc_subtype_tbl g_doc_subtype_tbl_type;

Line 163: * B. Use the PO_DOCUMENT_TYPES_B base view instead of PO_DOCUMENT_TYPES

159: * A. Removing the 6 way cartesian join all on the same table.
160: * Instead, use a PL-SQL table variable to store the data
161: * we need, and then loop through it. This should avoid the
162: * massive join while also avoiding 6 PL/SQL to SQL context switches.
163: * B. Use the PO_DOCUMENT_TYPES_B base view instead of PO_DOCUMENT_TYPES
164: * There is no need for translation in this code, so the base view, which
165: * does not join with a translation table is a better choice.
166: * Note: we use three PL-SQL tables, as in 8I DB, you cannot bulk collect
167: * into a table of records! In 9I, that is allowed, but for now,

Line 173: FROM po_document_types_b

169: */
170:
171: SELECT security_level_code, document_type_code, document_subtype
172: BULK COLLECT into l_sec_level_tbl, l_doc_type_code_tbl, l_doc_subtype_tbl
173: FROM po_document_types_b
174: WHERE (document_type_code = 'PO' and document_subtype = 'STANDARD')
175: or (document_type_code = 'PA' and document_subtype = 'BLANKET')
176: or (document_type_code = 'PA' and document_subtype = 'CONTRACT')
177: or (document_type_code = 'PO' and document_subtype = 'PLANNED')