DBA Data[Home] [Help]

APPS.IBC_CITEM_WORKFLOW_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 89: FROM jtf_rs_resource_extns

85: AND rgr.delete_flag = 'N';
86:
87: CURSOR c_user_name(p_resource_id IN NUMBER) IS
88: SELECT resource_number, user_name
89: FROM jtf_rs_resource_extns
90: WHERE resource_id = p_resource_id;
91:
92: BEGIN
93:

Line 333: FROM jtf_rs_resource_extns

329: 'SUPPLIER_CONTACT', 'RS_SUPPLIER' ,
330: 'PARTY', 'RS_PARTY' ,
331: 'OTHER','RS_OTHER',
332: 'TBH', 'RS_TBH') resource_type
333: FROM jtf_rs_resource_extns
334: WHERE user_id = FND_GLOBAL.USER_ID;
335:
336: CURSOR c_owner(p_citem_ver_id NUMBER) IS
337: SELECT owner_resource_id,

Line 1878: FROM jtf_rs_resource_extns

1874: ,'SUPPLIER_CONTACT', 'RS_SUPPLIER'
1875: ,'PARTY', 'RS_PARTY'
1876: ,'OTHER','RS_OTHER'
1877: ,'TBH', 'RS_TBH') resource_type
1878: FROM jtf_rs_resource_extns
1879: WHERE user_id = FND_GLOBAL.USER_ID;
1880:
1881: CURSOR c_owner(p_citem_ver_id NUMBER) IS
1882: SELECT CITEM.owner_resource_id