DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on CST_ACTIVITIES

Line 106: cst_activities ca,

102:
103: CURSOR c_res_cur IS --rhshriva
104: select br.resource_id,br.resource_code,br.resource_type
105: from
106: cst_activities ca,
107: bom_department_resources bdr,
108: bom_resources br
109: where br.organization_id = p_organization_id
110: and bdr.department_id = (select department_id

Line 125: from cst_activities ca,

121: CURSOR c_res_seq_num IS --rhshriva
122: select wor.resource_seq_num,
123: br.resource_code,
124: br.resource_id
125: from cst_activities ca,
126: bom_resources br,
127: wip_operation_resources wor
128: where wor.repetitive_schedule_id is null
129: and br.organization_id = wor.organization_id

Line 786: cst_activities ca,

782: l_activity_id,
783: l_activity_name,
784: l_standard_rate_flag
785: from
786: cst_activities ca,
787: bom_department_resources bdr,
788: bom_resources br
789: where br.organization_id = l_organization_id
790: and bdr.department_id = (select department_id