APPS.CST_EAMJOB_ACTESTIMATE dependencies on BOM_RESOURCES

Line 56: FROM bom_resources

52: IF p_resource_id IS NOT NULL THEN
53: l_stmt_num := 200;
54: SELECT resource_type
55: INTO l_resource_type
56: FROM bom_resources
57: WHERE organization_id = p_org_id
58: AND resource_id = p_resource_id;
59: END IF; -- end checking resource id
60:

Line 410: bom_resources br,

406: br.resource_type resource_type
407: FROM bom_operational_routings bor,
408: bom_operation_resources bomres,
409: bom_operation_sequences bos,
410: bom_resources br,
411: cst_resource_costs crc
412: WHERE
413: bor.assembly_item_id = p_activity_item_id
414: AND bor.organization_id = p_organization_id