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.GR_PROCESS_DOCUMENTS dependencies on GR_ITEM_GENERAL

Line 32: (item_group_code gr_item_general.item_group_code%TYPE,

28: ** on the item group.
29: */
30:
31: TYPE print_ingredient IS RECORD
32: (item_group_code gr_item_general.item_group_code%TYPE,
33: line_text VARCHAR2(2000),
34: concentration NUMBER,
35: print_size NUMBER);
36:

Line 55: G_START_ITEM GR_ITEM_GENERAL.item_code%TYPE;

51: G_DOCUMENT_CODE GR_DOCUMENT_CODES.document_code%TYPE;
52: G_DISCLOSURE_CODE GR_DISCLOSURES.disclosure_code%TYPE;
53: G_ING_DISCLOSURE GR_DISCLOSURES.disclosure_code%TYPE;
54:
55: G_START_ITEM GR_ITEM_GENERAL.item_code%TYPE;
56: G_END_ITEM GR_ITEM_GENERAL.item_code%TYPE;
57:
58: G_CURRENT_PHRASE GR_PHRASES_B.phrase_code%TYPE;
59: G_CURRENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;

Line 56: G_END_ITEM GR_ITEM_GENERAL.item_code%TYPE;

52: G_DISCLOSURE_CODE GR_DISCLOSURES.disclosure_code%TYPE;
53: G_ING_DISCLOSURE GR_DISCLOSURES.disclosure_code%TYPE;
54:
55: G_START_ITEM GR_ITEM_GENERAL.item_code%TYPE;
56: G_END_ITEM GR_ITEM_GENERAL.item_code%TYPE;
57:
58: G_CURRENT_PHRASE GR_PHRASES_B.phrase_code%TYPE;
59: G_CURRENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
60: G_ML_ITEM GR_ITEM_GENERAL.item_code%TYPE;

Line 59: G_CURRENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;

55: G_START_ITEM GR_ITEM_GENERAL.item_code%TYPE;
56: G_END_ITEM GR_ITEM_GENERAL.item_code%TYPE;
57:
58: G_CURRENT_PHRASE GR_PHRASES_B.phrase_code%TYPE;
59: G_CURRENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
60: G_ML_ITEM GR_ITEM_GENERAL.item_code%TYPE;
61: G_CURRENT_LABEL GR_LABELS_B.label_code%TYPE;
62: G_OPM_VERSION FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
63: G_MAIN_HEADING GR_MAIN_HEADINGS_B.main_heading_code%TYPE;

Line 60: G_ML_ITEM GR_ITEM_GENERAL.item_code%TYPE;

56: G_END_ITEM GR_ITEM_GENERAL.item_code%TYPE;
57:
58: G_CURRENT_PHRASE GR_PHRASES_B.phrase_code%TYPE;
59: G_CURRENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
60: G_ML_ITEM GR_ITEM_GENERAL.item_code%TYPE;
61: G_CURRENT_LABEL GR_LABELS_B.label_code%TYPE;
62: G_OPM_VERSION FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
63: G_MAIN_HEADING GR_MAIN_HEADINGS_B.main_heading_code%TYPE;
64: G_SUB_HEADING GR_SUB_HEADINGS_B.sub_heading_code%TYPE;

Line 70: G_GENERIC_ITEM GR_ITEM_GENERAL.item_code%TYPE;

66: G_LANGUAGE_CODE FND_LANGUAGES.language_code%TYPE;
67: G_RECIP_PRINTED VARCHAR2(2) := 'NO';
68: G_VENDOR_PRINTED VARCHAR2(2) := 'NO';
69: G_GENERIC_STATUS VARCHAR2(7) := 'UNKNOWN';
70: G_GENERIC_ITEM GR_ITEM_GENERAL.item_code%TYPE;
71: G_ITEMS_TO_PRINT VARCHAR2(1);
72: G_MASTER_ITEM GR_ITEM_GENERAL.item_code%TYPE;
73: G_DOCUMENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
74: G_START_GENERIC GR_ITEM_GENERAL.item_code%TYPE;

Line 72: G_MASTER_ITEM GR_ITEM_GENERAL.item_code%TYPE;

68: G_VENDOR_PRINTED VARCHAR2(2) := 'NO';
69: G_GENERIC_STATUS VARCHAR2(7) := 'UNKNOWN';
70: G_GENERIC_ITEM GR_ITEM_GENERAL.item_code%TYPE;
71: G_ITEMS_TO_PRINT VARCHAR2(1);
72: G_MASTER_ITEM GR_ITEM_GENERAL.item_code%TYPE;
73: G_DOCUMENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
74: G_START_GENERIC GR_ITEM_GENERAL.item_code%TYPE;
75: G_END_GENERIC GR_ITEM_GENERAL.item_code%TYPE;
76:

Line 73: G_DOCUMENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;

69: G_GENERIC_STATUS VARCHAR2(7) := 'UNKNOWN';
70: G_GENERIC_ITEM GR_ITEM_GENERAL.item_code%TYPE;
71: G_ITEMS_TO_PRINT VARCHAR2(1);
72: G_MASTER_ITEM GR_ITEM_GENERAL.item_code%TYPE;
73: G_DOCUMENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
74: G_START_GENERIC GR_ITEM_GENERAL.item_code%TYPE;
75: G_END_GENERIC GR_ITEM_GENERAL.item_code%TYPE;
76:
77: G_CURRENT_DATE DATE := sysdate;

Line 74: G_START_GENERIC GR_ITEM_GENERAL.item_code%TYPE;

70: G_GENERIC_ITEM GR_ITEM_GENERAL.item_code%TYPE;
71: G_ITEMS_TO_PRINT VARCHAR2(1);
72: G_MASTER_ITEM GR_ITEM_GENERAL.item_code%TYPE;
73: G_DOCUMENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
74: G_START_GENERIC GR_ITEM_GENERAL.item_code%TYPE;
75: G_END_GENERIC GR_ITEM_GENERAL.item_code%TYPE;
76:
77: G_CURRENT_DATE DATE := sysdate;
78: G_SUPERCEDE_DATE DATE := sysdate;

Line 75: G_END_GENERIC GR_ITEM_GENERAL.item_code%TYPE;

71: G_ITEMS_TO_PRINT VARCHAR2(1);
72: G_MASTER_ITEM GR_ITEM_GENERAL.item_code%TYPE;
73: G_DOCUMENT_ITEM GR_ITEM_GENERAL.item_code%TYPE;
74: G_START_GENERIC GR_ITEM_GENERAL.item_code%TYPE;
75: G_END_GENERIC GR_ITEM_GENERAL.item_code%TYPE;
76:
77: G_CURRENT_DATE DATE := sysdate;
78: G_SUPERCEDE_DATE DATE := sysdate;
79:

Line 295: gr_item_general ig1

291: pc.product_class_desc
292: FROM gr_emea em,
293: gr_product_classes pc,
294: fnd_user fnu,
295: gr_item_general ig1
296: WHERE ig1.item_code >= g_start_item
297: AND ig1.item_code <= g_end_item
298: AND ig1.user_id = fnu.user_id
299: AND ig1.product_class = pc.product_class (+)

Line 316: gr_item_general ig1,

312: em.eec_number,
313: em.consolidated_risk_phrase,
314: em.consolidated_safety_phrase
315: FROM gr_emea em,
316: gr_item_general ig1,
317: gr_item_concentrations ic
318: WHERE ic.item_code = GlobalItemRecord.item_code
319: AND ic.ingredient_item_code = em.item_code (+)
320: AND ic.ingredient_item_code = ig1.item_code