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 121: from ic_whse_mst

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