APPS.GR_PROCESS_ORDERS dependencies on GR_ITEM_GENERAL

Line 10: G_ITEM_CODE GR_ITEM_GENERAL.item_code%TYPE;

6: */
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GR_PROCESS_DOCUMENTS';
8: G_BATCH_NUMBER GR_SELECTION_HEADER.batch_no%TYPE;
9: G_RECIPIENT_CODE GR_RECIPIENT_INFO.recipient_code%TYPE;
10: G_ITEM_CODE GR_ITEM_GENERAL.item_code%TYPE;
11: G_SHIPMENT_NUMBER OP_BILL_LAD.bol_no%TYPE;
12:
13: G_NO_CUSTOMER_PRINT VARCHAR2(1);
14: G_DEFAULT_COUNTRY FND_TERRITORIES.territory_code%TYPE;

Line 40: G_DOC_ITEM_CODE GR_ITEM_GENERAL.ITEM_CODE%TYPE;

36:
37: /* 17-Jun-2003 Mercy Thomas BUG 2932007 - Added the following Global Variables for Document Management */
38:
39: G_ORDER_NO GR_ORDER_INFO_V.order_no%TYPE;
40: G_DOC_ITEM_CODE GR_ITEM_GENERAL.ITEM_CODE%TYPE;
41: G_REPORT_TYPE NUMBER:=0;
42: G_COVER_LETTER VARCHAR2(2) := 'N';
43:
44: /* 17-Jun-2003 Mercy Thomas BUG 2932007 - End of code changes */

Line 81: FROM gr_item_general ig1

77: SELECT ig1.primary_cas_number,
78: ig1.formula_source_indicator,
79: ig1.ingredient_flag,
80: ig1.print_ingredient_phrases_flag
81: FROM gr_item_general ig1
82: WHERE ig1.item_code = g_item_code;
83: GlobalSafetyRecord g_get_item_safety%ROWTYPE;
84: /*
85: ** Get the generic item information

Line 96: FROM gr_item_general ig1,

92: ig1.print_ingredient_phrases_flag,
93: ig1.item_code,
94: gi.item_no,
95: gi.default_document_name_flag
96: FROM gr_item_general ig1,
97: gr_generic_items_b gi
98: WHERE gi.item_no = g_item_code
99: AND gi.item_code = ig1.item_code;
100: GlobalGenericRecord g_get_generic_item%ROWTYPE;