DBA Data[Home] [Help]

APPS.GR_PROCESS_ORDERS dependencies on GR_RECIPIENT_INFO

Line 9: G_RECIPIENT_CODE GR_RECIPIENT_INFO.recipient_code%TYPE;

5: ** Global Alpha variables
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);

Line 117: FROM gr_recipient_info ri,

113: ri.shipping_address,
114: ri.invoice_address,
115: ri.additional_address_flag,
116: cp.language
117: FROM gr_recipient_info ri,
118: gr_country_profiles cp
119: WHERE ri.recipient_code = g_recipient_code
120: AND ri.territory_code = cp.territory_code;
121: GlobalRecipient g_get_recipient%ROWTYPE;