eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_FTE_COMP_CONSTRAINTS

Line 704: FROM WSH_FTE_COMP_CONSTRAINTS

700: IS
701:
702: CURSOR c_get_constraint_info(c_constraint_id IN NUMBER) IS
703: SELECT *
704: FROM WSH_FTE_COMP_CONSTRAINTS
705: WHERE COMPATIBILITY_ID = c_constraint_id;
706:
707: l_comp_type1 VARCHAR2(3);
708: l_comp_type2 VARCHAR2(3);

Line 712: l_constraint_rec WSH_FTE_COMP_CONSTRAINTS%ROWTYPE;

708: l_comp_type2 VARCHAR2(3);
709: l_fac_company_type VARCHAR2(30) := NULL;
710: l_fac_company_name VARCHAR2(2000) := NULL;
711: l_severity VARCHAR2(30);
712: l_constraint_rec WSH_FTE_COMP_CONSTRAINTS%ROWTYPE;
713:
714: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
715: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'get_constraint_display';
716:

Line 1899: FROM WSH_FTE_COMP_CONSTRAINTS

1895: IS
1896:
1897: CURSOR c_get_constraint_info(c_comp_class_id IN NUMBER) IS
1898: SELECT *
1899: FROM WSH_FTE_COMP_CONSTRAINTS
1900: WHERE COMPATIBILITY_CLASS_ID = nvl(c_comp_class_id,COMPATIBILITY_CLASS_ID)
1901: AND nvl(trunc(EFFECTIVE_DATE_FROM,'DDD'),trunc(sysdate,'DDD')) <= trunc(sysdate,'DDD')
1902: AND nvl(trunc(EFFECTIVE_DATE_TO,'DDD'),trunc(sysdate,'DDD')) >= trunc(sysdate,'DDD');
1903:

Line 1907: l_constraint_rec WSH_FTE_COMP_CONSTRAINTS%ROWTYPE;

1903:
1904: l_hash_string VARCHAR2(200):=NULL;
1905: l_hash_value NUMBER:=0;
1906: l_comp_class_id NUMBER:=NULL;
1907: l_constraint_rec WSH_FTE_COMP_CONSTRAINTS%ROWTYPE;
1908:
1909: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'populate_constraint_cache';
1910: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1911:

Line 2254: FROM WSH_FTE_COMP_CONSTRAINTS

2250: IS
2251:
2252: CURSOR c_get_constraint_info(c_comp_class_id IN NUMBER) IS
2253: SELECT *
2254: FROM WSH_FTE_COMP_CONSTRAINTS
2255: WHERE COMPATIBILITY_CLASS_ID = c_comp_class_id
2256: AND CONSTRAINT_TYPE = 'I'
2257: AND nvl(trunc(EFFECTIVE_DATE_FROM,'DDD'),trunc(sysdate,'DDD')) <= trunc(sysdate,'DDD')
2258: AND nvl(trunc(EFFECTIVE_DATE_TO,'DDD'),trunc(sysdate,'DDD')) >= trunc(sysdate,'DDD');

Line 2261: l_constraint_rec WSH_FTE_COMP_CONSTRAINTS%ROWTYPE;

2257: AND nvl(trunc(EFFECTIVE_DATE_FROM,'DDD'),trunc(sysdate,'DDD')) <= trunc(sysdate,'DDD')
2258: AND nvl(trunc(EFFECTIVE_DATE_TO,'DDD'),trunc(sysdate,'DDD')) >= trunc(sysdate,'DDD');
2259:
2260: itr NUMBER := 0;
2261: l_constraint_rec WSH_FTE_COMP_CONSTRAINTS%ROWTYPE;
2262: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'populate_reg_const_cache';
2263: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2264:
2265: BEGIN

Line 17788: SELECT constraint_object2_id from wsh_fte_comp_constraints

17784: -- AG add compatibility_class_id = 2
17785: -- as otherwise there is a small chance of wrongly picking up
17786: -- a supplier facility - facility constraint
17787: CURSOR c_get_must_use_location (c_object1_type VARCHAR2, c_object1_id NUMBER, c_class_id NUMBER) IS
17788: SELECT constraint_object2_id from wsh_fte_comp_constraints
17789: WHERE constraint_object2_type = 'FAC'
17790: AND constraint_object1_type = c_object1_type
17791: AND constraint_object1_id = c_object1_id
17792: AND Constraint_type = 'I'

Line 17798: SELECT constraint_object2_id from wsh_fte_comp_constraints

17794: AND nvl(trunc(EFFECTIVE_DATE_FROM,'DDD'),trunc(sysdate,'DDD')) <= trunc(sysdate,'DDD')
17795: AND nvl(trunc(EFFECTIVE_DATE_TO,'DDD'),trunc(sysdate,'DDD')) >= trunc(sysdate,'DDD');
17796:
17797: /*CURSOR c_get_must_use_cus_fac (c_object1_id NUMBER) IS
17798: SELECT constraint_object2_id from wsh_fte_comp_constraints
17799: WHERE constraint_object1_type = 'CUS'
17800: AND constraint_object2_type = 'FAC'
17801: AND constraint_object1_id = c_object1_id
17802: AND Constraint_type = 'I'

Line 17807: SELECT constraint_object1_id, constraint_object2_id from wsh_fte_comp_constraints

17803: AND nvl(trunc(EFFECTIVE_DATE_FROM,'DDD'),trunc(sysdate,'DDD')) <= trunc(sysdate,'DDD')
17804: AND nvl(trunc(EFFECTIVE_DATE_TO,'DDD'),trunc(sysdate,'DDD')) >= trunc(sysdate,'DDD');*/
17805:
17806: CURSOR c_get_region_incl_constraints IS
17807: SELECT constraint_object1_id, constraint_object2_id from wsh_fte_comp_constraints
17808: WHERE constraint_type = 'I'
17809: AND compatibility_class_id=12
17810: AND nvl(trunc(EFFECTIVE_DATE_FROM,'DDD'),trunc(sysdate,'DDD')) <= trunc(sysdate,'DDD')
17811: AND nvl(trunc(EFFECTIVE_DATE_TO,'DDD'),trunc(sysdate,'DDD')) >= trunc(sysdate,'DDD')