DBA Data[Home] [Help]

APPS.WSH_SC_TRX_INTERFACE dependencies on MTL_PARAMETERS

Line 71: FROM MTL_PARAMETERS

67: AND dtl.warehouse_id = decode(check_org, 'Y', X_warehouse_id, dtl.warehouse_id);
68:
69: CURSOR IN_MTL_PARAM IS
70: SELECT serial_number_type
71: FROM MTL_PARAMETERS
72: WHERE organization_id = X_warehouse_id;
73:
74: BEGIN
75: check_org := 'N';

Line 177: from MTL_PARAMETERS

173: X_ERROR_CODE IN OUT NUMBER) IS
174:
175: Cursor IN_MTL_PARAM IS
176: select serial_number_type
177: from MTL_PARAMETERS
178: where organization_id = X_warehouse_id;
179:
180: X_Cursor NUMBER;
181: X_Stmt VARCHAR2(5000);