DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on CST_ACTIVITIES

Line 107: cst_activities ca,

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

Line 126: from cst_activities ca,

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

Line 853: cst_activities ca,

849: l_activity_id,
850: l_activity_name,
851: l_standard_rate_flag
852: from
853: cst_activities ca,
854: bom_department_resources bdr,
855: bom_resources br
856: where br.organization_id = l_organization_id
857: and bdr.department_id = (select department_id