APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_RESOURCES

Line 95: v_resource_code BOM_RESOURCES.RESOURCE_CODE%TYPE;

91: l_status_type NUMBER ;
92: l_we_entity_type NUMBER ;
93:
94:
95: v_resource_code BOM_RESOURCES.RESOURCE_CODE%TYPE;
96:
97: --added the cursor in the declare section instead of putting inline cursors
98: CURSOR c_res_in_bom_cur IS --rhshriva
99: Select resource_id,resource_code

Line 100: from bom_resources

96:
97: --added the cursor in the declare section instead of putting inline cursors
98: CURSOR c_res_in_bom_cur IS --rhshriva
99: Select resource_id,resource_code
100: from bom_resources
101: where organization_id =p_organization_id;
102:
103: CURSOR c_res_cur IS --rhshriva
104: select br.resource_id,br.resource_code,br.resource_type

Line 108: bom_resources br

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
111: from wip_operations
112: where organization_id = p_organization_id

Line 126: bom_resources br,

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
130: and wor.resource_id = br.resource_id

Line 149: from bom_resources

145: and muc.uom_class in (select muc2.uom_class
146: from mtl_uom_conversions muc2
147: where muc2.inventory_item_id = 0
148: and muc2.uom_code in (select unit_of_measure
149: from bom_resources
150: where resource_id in (select distinct resource_id
151: from bom_resources
152: where resource_id = l_temp_res_id1 )) and
153: nvl(muc2.disable_date, sysdate +1 ) > sysdate)

Line 151: from bom_resources

147: where muc2.inventory_item_id = 0
148: and muc2.uom_code in (select unit_of_measure
149: from bom_resources
150: where resource_id in (select distinct resource_id
151: from bom_resources
152: where resource_id = l_temp_res_id1 )) and
153: nvl(muc2.disable_date, sysdate +1 ) > sysdate)
154: and nvl(muc.disable_date,sysdate+1) >sysdate;
155:

Line 258: -- Check whether the resource code entered is valid and matches with a resource in BOM_RESOURCES

254: resource_exists := 1;
255:
256: l_stmt_num := 70;
257:
258: -- Check whether the resource code entered is valid and matches with a resource in BOM_RESOURCES
259: open c_res_cur ;
260:
261: l_stmt_num := 75;
262:

Line 316: select resource_id into l_resource_id from bom_resources where resource_code = p_resource_code and organization_id = p_organization_id ;

312:
313: -- Check the resource code - resource sequence combination, in order to verify any illegal entry throgh the JSP
314:
315: if (p_resource_code is not null) then
316: select resource_id into l_resource_id from bom_resources where resource_code = p_resource_code and organization_id = p_organization_id ;
317: end if;
318:
319: if(l_resource_id <> 0 and l_resource_seq_num is null) then
320:

Line 788: bom_resources br

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
791: from wip_operations
792: where organization_id = l_organization_id