DBA Data[Home] [Help]

APPS.GR_PROCESS_ORDERS dependencies on GR_SELECTION_HEADER

Line 8: G_BATCH_NUMBER GR_SELECTION_HEADER.batch_no%TYPE;

4: /*
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:

Line 69: FROM gr_selection_header sh

65: sh.shipment_date_to,
66: sh.orgn_code,
67: sh.whse_code,
68: sh.territory_code
69: FROM gr_selection_header sh
70: WHERE sh.batch_no = g_batch_number;
71: GlobalBatchHeader g_get_batch_status%ROWTYPE;
72: /*
73: ** Get the item general information