DBA Data[Home] [Help]

APPS.EAM_OPERATIONS_JSP dependencies on CST_ACTIVITIES

Line 1779: from cst_activities cst, mtl_uom_conversions muc, bom_resources res, bom_department_resources bdr

1775:
1776: CURSOR c_res_cur IS --rhshriva
1777: select res.resource_code,
1778: res.unit_of_measure
1779: from cst_activities cst, mtl_uom_conversions muc, bom_resources res, bom_department_resources bdr
1780: where nvl(res.disable_date,sysdate+2) > sysdate
1781: and res.resource_id = bdr.resource_id
1782: and res.default_activity_id = cst.activity_id(+)
1783: and (cst.organization_id = res.organization_id or cst.organization_id is null)

Line 1806: from cst_activities

1802:
1803:
1804: CURSOR c_act_cur IS --rhshriva
1805: select activity
1806: from cst_activities
1807: where nvl(disable_date, sysdate + 2) > sysdate and
1808: (organization_id is null or organization_id = p_organization_id ) ;
1809:
1810: BEGIN

Line 2015: from cst_activities

2011:
2012: begin
2013: select activity_id
2014: into l_activity_id
2015: from cst_activities
2016: where activity = p_activity
2017: and organization_id = organization_id;
2018:
2019: exception