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.MSC_CL_SUPPLIER_RESP dependencies on MSC_ST_SUPPLIES

Line 19: TYPE order_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_NUMBER%TYPE;

15: G_ORGANIZATION CONSTANT NUMBER := 3;
16:
17: /* Collection variables */
18: TYPE number_arr IS TABLE OF NUMBER;
19: TYPE order_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_NUMBER%TYPE;
20: TYPE order_line_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_LINE_NUMBER%TYPE;
21: TYPE dates IS TABLE OF DATE;
22: TYPE end_order_numbers IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_NUMBER%TYPE;
23: TYPE end_order_line_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_LINE_NUMBER%TYPE;

Line 20: TYPE order_line_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_LINE_NUMBER%TYPE;

16:
17: /* Collection variables */
18: TYPE number_arr IS TABLE OF NUMBER;
19: TYPE order_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_NUMBER%TYPE;
20: TYPE order_line_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_LINE_NUMBER%TYPE;
21: TYPE dates IS TABLE OF DATE;
22: TYPE end_order_numbers IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_NUMBER%TYPE;
23: TYPE end_order_line_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_LINE_NUMBER%TYPE;
24: TYPE end_order_rel_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_RELEASE_NUMBER%TYPE;

Line 22: TYPE end_order_numbers IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_NUMBER%TYPE;

18: TYPE number_arr IS TABLE OF NUMBER;
19: TYPE order_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_NUMBER%TYPE;
20: TYPE order_line_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_LINE_NUMBER%TYPE;
21: TYPE dates IS TABLE OF DATE;
22: TYPE end_order_numbers IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_NUMBER%TYPE;
23: TYPE end_order_line_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_LINE_NUMBER%TYPE;
24: TYPE end_order_rel_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_RELEASE_NUMBER%TYPE;
25: TYPE company_names IS TABLE OF MSC_COMPANIES.COMPANY_NAME%TYPE;
26: TYPE company_site_names IS TABLE OF MSC_COMPANY_SITES.COMPANY_SITE_NAME%TYPE;

Line 23: TYPE end_order_line_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_LINE_NUMBER%TYPE;

19: TYPE order_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_NUMBER%TYPE;
20: TYPE order_line_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_LINE_NUMBER%TYPE;
21: TYPE dates IS TABLE OF DATE;
22: TYPE end_order_numbers IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_NUMBER%TYPE;
23: TYPE end_order_line_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_LINE_NUMBER%TYPE;
24: TYPE end_order_rel_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_RELEASE_NUMBER%TYPE;
25: TYPE company_names IS TABLE OF MSC_COMPANIES.COMPANY_NAME%TYPE;
26: TYPE company_site_names IS TABLE OF MSC_COMPANY_SITES.COMPANY_SITE_NAME%TYPE;
27: TYPE item_names IS TABLE OF MSC_SUP_DEM_ENTRIES.ITEM_NAME%TYPE;

Line 24: TYPE end_order_rel_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_RELEASE_NUMBER%TYPE;

20: TYPE order_line_numbers IS TABLE OF MSC_ST_SUPPLIES.ORDER_LINE_NUMBER%TYPE;
21: TYPE dates IS TABLE OF DATE;
22: TYPE end_order_numbers IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_NUMBER%TYPE;
23: TYPE end_order_line_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_LINE_NUMBER%TYPE;
24: TYPE end_order_rel_nums IS TABLE OF MSC_ST_SUPPLIES.END_ORDER_RELEASE_NUMBER%TYPE;
25: TYPE company_names IS TABLE OF MSC_COMPANIES.COMPANY_NAME%TYPE;
26: TYPE company_site_names IS TABLE OF MSC_COMPANY_SITES.COMPANY_SITE_NAME%TYPE;
27: TYPE item_names IS TABLE OF MSC_SUP_DEM_ENTRIES.ITEM_NAME%TYPE;
28: TYPE item_descriptions IS TABLE OF MSC_SUP_DEM_ENTRIES.ITEM_description%TYPE;

Line 31: TYPE acceptance_required_flags IS TABLE OF MSC_ST_SUPPLIES.ACCEPTANCE_REQUIRED_FLAG%TYPE;

27: TYPE item_names IS TABLE OF MSC_SUP_DEM_ENTRIES.ITEM_NAME%TYPE;
28: TYPE item_descriptions IS TABLE OF MSC_SUP_DEM_ENTRIES.ITEM_description%TYPE;
29: TYPE tp_uom_codes IS TABLE OF MSC_SUP_DEM_ENTRIES.tp_uom_code%TYPE;
30: TYPE order_types IS TABLE OF MSC_SUP_DEM_ENTRIES.publisher_order_type_desc%TYPE;
31: TYPE acceptance_required_flags IS TABLE OF MSC_ST_SUPPLIES.ACCEPTANCE_REQUIRED_FLAG%TYPE;
32: TYPE ack_reference_numbers IS TABLE OF MSC_ST_SUPPLIES.ACK_REFERENCE_NUMBER%TYPE;
33:
34:
35: /* Procedures */

Line 32: TYPE ack_reference_numbers IS TABLE OF MSC_ST_SUPPLIES.ACK_REFERENCE_NUMBER%TYPE;

28: TYPE item_descriptions IS TABLE OF MSC_SUP_DEM_ENTRIES.ITEM_description%TYPE;
29: TYPE tp_uom_codes IS TABLE OF MSC_SUP_DEM_ENTRIES.tp_uom_code%TYPE;
30: TYPE order_types IS TABLE OF MSC_SUP_DEM_ENTRIES.publisher_order_type_desc%TYPE;
31: TYPE acceptance_required_flags IS TABLE OF MSC_ST_SUPPLIES.ACCEPTANCE_REQUIRED_FLAG%TYPE;
32: TYPE ack_reference_numbers IS TABLE OF MSC_ST_SUPPLIES.ACK_REFERENCE_NUMBER%TYPE;
33:
34:
35: /* Procedures */
36: PROCEDURE PULL_SUPPLIER_RESP(p_dblink IN varchar2,