DBA Data[Home] [Help]

APPS.RCV_DATES_S dependencies on IC_WHSE_MST

Line 58: x_whse_code ic_whse_mst.whse_code%type := NULL;

54:
55: x_progress VARCHAR2(3) := NULL;
56: x_shipped_date DATE := NULL;
57: x_opm_orgn sy_orgn_mst.orgn_Code%type := NULL;
58: x_whse_code ic_whse_mst.whse_code%type := NULL;
59: v_retval NUMBER := 0;
60:
61: BEGIN
62:

Line 124: from ic_whse_mst

120: /*Bug# 1548597 check if for this proess receipt the OPM inventory calendars are open*/
121: /*If PO_GML_DB_COMMON.CHECK_PROCESS_ORG(x_org_id) = 'Y' then
122: Select whse_code,orgn_code
123: into x_whse_code,x_opm_orgn
124: from ic_whse_mst
125: where mtl_organization_id = x_org_id;
126:
127: v_retval := GMICCAL.trans_date_validate(
128: inv_le_timezone_pub.get_le_day_for_inv_org(x_trx_date, x_org_id),